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 / amit
read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is merge stage?
What is the difference between validated and compiled in the datastage?
How can one find bugs in job sequence?
What is the project in datastage?
State the difference between an operational datastage and a data warehouse?
How a server job can be converted to a parallel job?
What steps should be taken to improve Datastage jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How to perform incremental load in datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How a source file is populated?
What is the sortmerge collector?
Define repository tables in datastage?
What is a ds designer?