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 filter data in hashed file?
how to delete one row in target dataset
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Define Merge?
What is ds designer?
What are some prerequisites for datastage?
Can you explain kafka connector?
What are the types of hashed files in data stage
What is the process of killing a job in datastage?
What is active and passive stage?
Describe link sort?
how to export or import the jobs in .ISX file
What is the difference between account and directory options ?
How to Remove Duplicate using SQL?
Different ways a project can be moved to production ?...example ….export-import and Version control.