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 / satyanarayana

take one copy stage and then take two output links from copy
stage and next these two o/p links given to funnel stage and
provide option called 'sequential mode' in funnel stage then
you will get req output.

Is This Answer Correct ?    18 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1088


What is data partitioning?

747


In Datastage, how you can fix the truncated data error?

645


How will you move hashed file from one location to another location?

1663


What is staging variable?

626






Explain how a source file is populated?

769


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2187


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

960


Define Data Stage?

647


What are the types of hashed files in data stage

650


Differentiate between datastage and informatica?

731


Have you used Unstructured data?

841


how to sort two columns in single job in datastage.

2549


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1636


What are the functionalities of link collector?

631