I will describing the process below please let me know where the problem might be:
We have a update surrogate key job which updates the state file with the maximum value in the target table.
Before it updates the statefile, in before job subroutine this job runs a touch command with the state file name
so that if the state file does not exist it creates it.(this is helpful for the first run)
Now i created new job to view the contents of the state file, this job has only surrogate key stage in it.
when i run this job and check in director for its contents:
Why i am seeing 2 times 1, even though i am running surrogate key generator stage in sequential mode. Is this an issue?Surrogate_Key_Generator_0,0: Content of state file /etl/process/dev/cfg/skey_product.ctl:
1 1
And do you see any issue with the creation of state file using touch command.
NOTE: We are using surrogate key generator in sequential mode.