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
How one source columns or rows to be loaded in to two different tables?
How many types of stage?
How many Key we can define in remove duplicate stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define project in datastage?
How to Remove Duplicate using SQL?
What is usage analysis in datastage?
What are the areas of application?
Can you define merge?
How do you remove duplicate values in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
sed,awk,head
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between orabulk and bcp stages?