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
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between an operational datastage and a data warehouse?
why do u need the IOS upgradation in a FC switch
how can we create rank using datastage?what is the meaning of rank?
Why fact table is in normal form?
What are some prerequisites for datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
client know skid info?
What are the different plug-ins stages used in your projects?
How to perform incremental load in datastage?
Define project in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Lookup constraints
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Nls stands for what in datastage?