Page 1 of 1

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

Posted: Tue Feb 06, 2007 8:59 am
by vramana
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

Posted: Tue Feb 06, 2007 9:02 am
by ArndW
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.

Posted: Tue Feb 06, 2007 9:31 am
by vramana
Iam not able to find sequence command stage. Can you help me

Posted: Tue Feb 06, 2007 9:35 am
by DSguru2B
Its in the sequence job. Its called the "Execute Command Stage"

Posted: Tue Feb 06, 2007 9:42 am
by vramana
DSguru2B wrote:Its in the sequence job. Its called the "Execute Command Stage"



Thanks. I will work with that.