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 / ramachandra rao
first of all question is not clear
ok fine
if u take source as sequential file there is one option is
there i.e rownumcolumn use this option it will create
sequnce number.
2.use columngenerator also we used
Thanks
chandu-09538627859
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the primary usages of datastage tool?
What is apt_config in datastage?
In Datastage, how you can fix the truncated data error?
What are some different alternative commands associated with "dsjob"?
Why do we use exception activity in Datastage?
Explain ibm infosphere information server and highlight its main features?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Differentiate between operational datastage (ods) and data warehouse?
How many Key we can define in remove duplicate stage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what are the errors,warnings in datastage
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the different common services in datastage?
What all are the different way to run a job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?