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
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is job control?
what is the use of materialized view?
How do you schedule or monitoring the job?
Describe the architecture of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is a ds designer?
How the ipc stage work?
Why do we use link partitioner and link collector in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How do you register plug-ins?
What are some different alternative commands associated with "dsjob"?
Explain how a source file is populated?
Difference between in process and inter process?