Problem with state file
Posted: Tue Jul 09, 2013 2:06 pm
I am facing a issue while using the surrogate key in the transformer, i am reading the max value from a column of a table and updating the surrogate key in the first job which runs in the sequential mode. the settings for the surrogate key generator stage in the job 1 are
key source updated action = update
source type = flat file
the max value that would be updating surrogate key is 10000.
So in job 2 when i am using the same surrogate key in transformer stage i was expecting the value more than 10000. But i am getting two sets for values one staring from 10000 and other starting from 1. how to generate only values greater than 10000?
i have went through the below link but didn't solved my problem.
viewtopic.php?t=127081
Even after deleting and recreating the state file it didn't helped me.
key source updated action = update
source type = flat file
the max value that would be updating surrogate key is 10000.
So in job 2 when i am using the same surrogate key in transformer stage i was expecting the value more than 10000. But i am getting two sets for values one staring from 10000 and other starting from 1. how to generate only values greater than 10000?
i have went through the below link but didn't solved my problem.
viewtopic.php?t=127081
Even after deleting and recreating the state file it didn't helped me.