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

What is the difference between in process and inter process?

663


What is oci?

848


What is a folder? Difference types of stages?

624


Define Merge?

872


What are the types of containers?

680






Can you implement SCD2 using join, transformer and funnel stage?

1078


What is process model?

1549


What is the difference between operational data stage (ods) and data warehouse?

667


What is the different type of jobs in datastage?

568


Lookup constraints

836


What are the different options associated with dsjob command?

931


What are the various kinds of containers available in datastage?

559


How and where you used hash file?

653


How do you import and export the datastage jobs?

730


Differentiate between odbc and drs stage?

591