how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
- 2 Answers
- 11589 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / kiran
There is a surrogate key option in transformer.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the flow of loading data into fact & dimensional tables?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are iconv and oconv?
What is the use of hoursfromtime() function in transformer stage in datastage?
Define Data Stage?
What are the some differences between 7.x and 8.x version of datastage?
Differentiate between operational datastage (ods) and data warehouse?
Differentiate between datastage and informatica?
What is the difference between orabulk and bcp stages?
How the ipc stage work?
how do u catch bad rows from OCI stage? And what CLI stands for?
Have you used Unstructured data?
What are the main differences you have observed between 7.x and 8.x version of datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
