i have source data like
empno,enmae
11 ,aa
12 ,bb
i want output like
empno,ename
11 ,aa
12 ,bb
11 ,aa
12 ,bb
Answer Posted / venugopal
Take source in the sequential file and take two copy stages
and map the columns to two copy stages and use funnel stage
to funnel the data from two copy stages and o/p into the
file now you can see the o/p is your requirement....
Hope this will help you...
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
Differentiate between datastage and datastage tx?
Differentiate between datastage and informatica?
What is the difference between datastage and informatica?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the use of hoursfromtime() function in transformer stage in datastage?
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?
AGGREGATOR default datatype
How a routine is called in datastage job?
What are the different layers in the information server architecture?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Describe link sort?
How we can covert server job to a parallel job?
What is the use of datastage director?