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
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the types of hashed files in data stage
Differentiate between datastage and datastage tx?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the types of containers in datastage?
What is quality stage?
What is size of a transaction and an array means in a datastage?
project Steps,hits, Project level HArd things,Solved methods?
How to read multiple files using a single datastage job if files have the same metadata?
What is oci?
CHANGE CAPTURE
What are some prerequisites for datastage?
Where do you see different stages in the designer?
What are the steps required to kill the job in Datastage?