source file is having 5 records while moving into target it
want to be 10 records
Answer Posted / subbuchamala
Different ways are:
1. SRC-->COPY-->(2links)-->FUNNEL-->TGT
from copy stage get 2 copies of output data and send to funnel.
2. SRC-->Transfermer-->(2links)-->FUNNEL-->TGT
in the TFM, map the all the columns to both the links and then funnel them.
3. SRC--->TGT(with append mode)
Run job 2 times with TGT Seq file mode as "Append"
4. 2 SRCs(2 same Seq file Stages)-->Funnel-->TGT
read the same file from 2 Seqfile Stages and send them to funnel.
5. SRC--->TGT
Add 2 "File" properties in the Seq file stage and for both of them give the same file name and path.
File=directory/file.txt
File=directory/file.txt
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain datastage architecture?
What all the types of jobs you developed?
Why do we use exception activity in Datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is datastage engine?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
in oracle target stage when we use load option and when we use upsert option?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Can we use target hash file as a lookup ?
State the difference between an operational datastage and a data warehouse?
How many Key we can define in remove duplicate stage?
What is a ds designer?
How one source columns or rows to be loaded in to two different tables?