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
I have a few records just I want to store data in to targets cycling way how?
project Steps,hits, Project level HArd things,Solved methods?
What are the job parameters?
What is the difference between an operational datastage and a data warehouse?
Notification Activity
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Define meta stage?
How a routine is called in datastage job?
Define repository tables in datastage?
What is the precedence of stage variables,derivations, and constraints?
Can you explain link buffering?
Can you implement SCD2 using join, transformer and funnel stage?
What are the functionalities of link partitioner?
What is quality stage?