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 / kiran
ok well vijay.ur quetion not proper k.
see u can use s_key,column genaretor stage.
and u can define user define query in source level and
populated to target like dbl click on source and set read
method is user deine and write query=select
rownum,ename,sal from emp(s/r table name).k
Thanks&Regards
kiran
9393363309
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Differentiate between hash file and sequential file?
What are the benefits of datastage?
Explain Quality stage?
whom do you report?
What is a merge in datastage?
What is the difference between passive stage and active stage?
What are the features of datastage flow designer?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the difference between hashfile and sequential file?
Define Job control?
Why fact table is in normal form?
Where do the datastage jobs get stored?
What is the process of killing a job in datastage?
Which commands are used to import and export the datastage jobs?
How a source file is populated?