debojyoti_datastage

 Profile Answers by debojyoti_datastage 

• Jul 20th, 2008

 

The main disadvantage of this stage comes when you use it second time around..

There you have to give the initial value of the surrogate key....

I faced the similar situation and the only way i found was to write a unix shell script which would give me max value of the surrogate key column.

Increase it by 1 in the script and run the job passing that value as the paramater...
which would be used as the initial value

rajul.ds

 Profile Answers by rajul.ds 

• Jul 22nd, 2008

 

to my concern if the data is not properly processed on nodes..in such suitations this surrogate key generates holes(simply skips the ordering )
ex:
aa-1
bb-2
ba..
bg...
cc-3
dd-4
ddd-5
here for ba and bg do not have seq key ,here ba and bg have holes