Hi I have scenario like this
s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000
How can i get target table like that without using
Transformer stage?
- 8 Answers
- 11190 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / surya
you can generate surrogate key in the transformer itself.
right click on the stage variables. tre you can find surrrogate key.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is aggtorec restructure operator?
Can you explain how could anyone drop the index before loading the data in target in datastage?
what is the use of surogate key in 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.
Define data aggregation?
Terminate Activity
What is the difference between account and directory options ?
What are constraints and derivations?
What all the types of jobs you developed?
What is a ds designer?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the method of removing duplicates, without the remove duplicate stage?
Define Merge?
Describe routines in datastage? Enlist various types of routines.
What is the process of killing a job in datastage?
