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?
Answer Posted / pavan
Hi This is pavan u use surrogate key generator.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is apt_config in datastage?
What are datastage sequences?
What is orabulk stage?
What are the differences between datastage and informatica?
What is the difference between datastage and datastage tx?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the components of datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is use Array size in datastage
Explain the importance of surrogate key in data warehousing?
What is the difference between passive stage and active stage?
What are constraints and derivations?
What all the types of jobs you developed?
options available in sequence job to run,validate?
How do you start developing a datastage project?