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
- 12740 Views
- Syntel, I also Faced
- E-Mail Answers
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
What are the different kinds of views available in a datastage director?
Highlight the main features of datastage?
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
Define orabulk and bcp stages?
What is the purpose of pivot stage?
What is the use of datastage designer?
Can you define merge?
root tree will find which is server job and which is parallel job?
How a routine is called in datastage job?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
what is the custome stage in datastage? how can we impliment that one? plz tell me
Difference between sequential file and data set?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
