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


Please Help Members By Posting Answers For Below Questions

Differentiate between Join, Merge and Lookup stage?

652


Differentiate between datastage and datastage tx?

601


Differentiate between datastage and informatica?

731


What is the difference between datastage and informatica?

616


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

2017






Difference between ‘validated ok’ and ‘compiled’ in data stage?

682


What is the use of hoursfromtime() function in transformer stage in datastage?

591


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?

2058


AGGREGATOR default datatype

939


How a routine is called in datastage job?

611


What are the different layers in the information server architecture?

647


What are the main differences you have observed between 7.x and 8.x version of datastage?

626


Describe link sort?

654


How we can covert server job to a parallel job?

601


What is the use of datastage director?

595