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
whom do you report?
What are the different common services in datastage?
What are the primary usages of datastage tool?
How do you reject records in a transformer?
how to sort two columns in single job in datastage.
options available in sequence job to run,validate?
What are the areas of application?
What are the types of containers?
What is "fatal error/rdbms code 3996" error?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the various kinds of containers available in datastage?
how to write server Routine coding?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between informatica and datastage?
What is the purpose of interprocessor stage in server jobs?