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

Take 2 sequentalfiles target dataset and processing funnel
stage.

note: Take similar structure we need common column names,
common datatypes then merging this process.....

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain how could anyone drop the index before loading the data in target in datastage?

1099


Explain connectivity between datastage with datasources?

687


How we can covert server job to a parallel job?

683


What is the flow of loading data into fact & dimensional tables?

689


Name the different types of Lookups in Datastage?

840






Define Merge?

984


What are system variables and sequencers in datastage

693


What is the purpose of interprocessor stage in server jobs?

1829


Why do you need stage variables?

801


How many Key we can define in remove duplicate stage?

920


Distinguish between informatica & datastage. Which one would you choose and why?

663


What is the difference between Datastage 7.5 and 7.0?

757


What is quality stage?

661


What is the difference between validated and compiled in the datastage?

786


How one source columns or rows to be loaded in to two different tables?

763