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 a folder? Difference types of stages?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the types of hashed files in data stage
What is active and passive stage?
What is the difference between passive stage and active stage?
What is difference between join, merge and lookup stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the difference between datastage and informatica?
Explain the situation where you have applied SCD in your project?
Can you implement SCD2 using join, transformer and funnel stage?
Which warehouse using in your datawarehouse
How many Key we can define in remove duplicate stage?
Why we use surrogate key?