Interested to Buy Any Domain ? << Click Here >> for more details...
how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
- 2 Answers
- 12905 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 |
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
How do you import and export data into datastage?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
whom do you report?
what is hash file
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
what is the differeces between hash and modulus partition methods
how do u capture duplicates through sort & transformer
plz tell me some dimentional and fact table names in banking project?
With out using Funnel Stage, how to populate the data from different sources to single target
Teradata 
