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 can we do null handling in sequential files?
when we have to go for a sequential file stage & for a dataset in datastage?
What is Horizontal transformation, vertical transformation,diagonal transformation?
What is lookup table?
Difference between sequential file and data set?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
What are the differences between datastage and informatica?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
how to find no.of records in sequntial file itself?
Give example for FACTLESS FACT TABLE in real-time scenario.