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
Why do we use link partitioner and link collector in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is difference between server jobs & parallel jobs?
What is aggtorec restructure operator?
How to clean the datastage repository?
describe the Steps to confiure a Qlogic switch
What is the difference between server job and parallel jobs?
Differentiate between datastage and datastage tx?
Whats difference betweeen operational data stage (ods) and data warehouse?
Describe link sort?
What is datastage?
Differentiate between validated and Compiled in the Datastage?
What are datastage sequences?
Define repository tables in datastage?
What are sequencers?