how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
- 2 Answers
- 12961 Views
- Syntel, I also Faced
- E-Mail Answers
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 LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
what about data stage requirement
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
how does work server jobs?
How do you design PX Routines ?
how to create document in datastage?
What is mapping?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the difference between the join and look up explin me one exmple
What are the features of datastage flow designer?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Explain how a source file is populated?
Teradata 
