Surrogate key not generated sequentially
Posted: Fri Jun 22, 2012 7:53 am
Hi,
I am trying to generate surrogate key from transformer stage in my job.
The job structure is as follows:
Database----Transformer------Datasets.
Now I am generating surrogate key in a stage Variable and passing it to all 4 datasets as a key.The job is running with 2 nodes.
I am using a sk file which I have defined in surrogate key tab,and incrementing it with 1 key values with initial value 1.
Now the issue I have is the keys are not generated sequentially.
I tried below steps:
1.Running in sequential mode from transformer onwards and clear partitioning.
In this case I am getting keys as 1,3,5,7,9,.............
2.Also running in parallel mode by setting the partitioning as round robin in input ,but this is generating some random values.
Can you please let me know what else I can try or if I am doing anything wrong?
Many thanks in advance.
I am trying to generate surrogate key from transformer stage in my job.
The job structure is as follows:
Database----Transformer------Datasets.
Now I am generating surrogate key in a stage Variable and passing it to all 4 datasets as a key.The job is running with 2 nodes.
I am using a sk file which I have defined in surrogate key tab,and incrementing it with 1 key values with initial value 1.
Now the issue I have is the keys are not generated sequentially.
I tried below steps:
1.Running in sequential mode from transformer onwards and clear partitioning.
In this case I am getting keys as 1,3,5,7,9,.............
2.Also running in parallel mode by setting the partitioning as round robin in input ,but this is generating some random values.
Can you please let me know what else I can try or if I am doing anything wrong?
Many thanks in advance.