how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
Answers were Sorted based on User's Feedback
Answer / 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 |
how to remove duplicates in transformer stage by using stage variables?one example?
Can you explain kafka connector?
what is a nodemap constraint
source contains 2 columns comes to target 4 columns how
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the default padding character?
Tell me Wt main advantage of Stage varibles? Project level hints?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe the architecture of datastage?
What is the importance of the exception activity in datastage?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle