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
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain connectivity between datastage with datasources?
How we can covert server job to a parallel job?
What is the flow of loading data into fact & dimensional tables?
Name the different types of Lookups in Datastage?
Define Merge?
What are system variables and sequencers in datastage
What is the purpose of interprocessor stage in server jobs?
Why do you need stage variables?
How many Key we can define in remove duplicate stage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between Datastage 7.5 and 7.0?
What is quality stage?
What is the difference between validated and compiled in the datastage?
How one source columns or rows to be loaded in to two different tables?