DSXchange

Hey, I am using simple surrogate key generator stage only available in 8.1. Could you please elaborate the concept with more explanation.
And alos it sould be better if you tell me, Is the approach fine ? If not how can i resolve the issue ?

I have designed a job as below 1) Source stage => Sequential file which is reading 3 columns as A,B,C. 2) Intermediate stage => Surrogate key generator stage where I am generating Column D. Here I am using Oracle Database sequence. 3) Target stage => Sequential File to capture all the columns A,B,C,...