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 are the functionalities of link collector?
Name the different sorting methods in datastage.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the roundrobin collector?
What is a quality stage in datastage tool?
What are the different types of lookups in datastage?
What is the difference between in process and inter process?
How do you import and export the datastage jobs?
Can you explain engine tier in information server?
What is the use of datastage designer?
What is the difference between odbc and drs stage?
What is process model?
explain about citrix scheduling tool in datastage
What are the main differences you have observed between 7.x and 8.x version of datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?