how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
Answer Posted / varma
In transformer Properties, there is a tab called “Surrogate Key”. Here we can define it.
We can select from
a. Flat file : State file which holds the SK values and generates SK values.
b. DB Sequence: Database sequence object to use to generate the SK values.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is aggtorec restructure operator?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Differentiate between hash file and sequential file?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are the different kinds of views available in a datastage director?
How we can covert server job to a parallel job?
What is the difference between informatica and datastage?
Is possible to create skid in dim,fact tables?
What are orabulk and bcp stages?
What is the difference between server job and parallel jobs?
How can we improve the performance in datastage?
Differentiate between odbc and drs stage?
How a source file is populated?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu