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


Please Help Members By Posting Answers For Below Questions

How many types of views are there in a datastage director?

830


What are the main differences you have observed between 7.x and 8.x version of datastage?

618


what are the devoleper roles in real time? plz tell i am new to datastage....

1630


What is datastage?

645


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2020






What is difference between server jobs & parallel jobs?

617


Enlist various types of routines in datastage.

639


Explain Quality stage?

661


What are the components of datastage?

643


Define Routines and their types?

616


What is the purpose of pivot stage and types of containers in datastage

607


Define orabulk and bcp stages?

669


What is the difference between odbc and drs stage?

634


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1693


What is quality stage?

565