How can we pass initial value to surrogate key stage from a

vramana · Post by **vramana** » Tue Feb 06, 2007 8:59 am

I have initial value stored in a flatfile. I want to pass that value to the initial value of the surrogate key stage. can anybody help me

ArndW · Post by **ArndW** » Tue Feb 06, 2007 9:02 am

Please post PX questions in the PX forum.

If you have just the value in a file, I would prefer using "cat" in a sequence command stage to get the value into a variable, and then passing that value as a parameter to your PX job and using the parameter to seed the surrogate key stage.

vramana · Post by **vramana** » Tue Feb 06, 2007 9:31 am

Iam not able to find sequence command stage. Can you help me

DSguru2B · Post by **DSguru2B** » Tue Feb 06, 2007 9:35 am

Its in the sequence job. Its called the "Execute Command Stage"

vramana · Post by **vramana** » Tue Feb 06, 2007 9:42 am

DSguru2B wrote:Its in the sequence job. Its called the "Execute Command Stage"

Thanks. I will work with that.