source file is having 5 records while moving into target it
want to be 10 records

Answers were Sorted based on User's Feedback



source file is having 5 records while moving into target it want to be 10 records..

Answer / rajesh

Hi This is Rajesh. use copy stage for multiple copies.From that take 2 links to funnel n load to target ...u wil get 10

Is This Answer Correct ?    15 Yes 0 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / sravanthirao64@gmail.com

target can create instance

Is This Answer Correct ?    6 Yes 4 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / srikanth

it's not a big issue create a one more node extra and select
the partition entire and run the job


thanks & regards
sriaknth.k
9573056597

Is This Answer Correct ?    5 Yes 4 No

source file is having 5 records while moving into target it want to be 10 records..

Answer / 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

More Data Stage Interview Questions

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  


what is time dimension? and how to populate time demension

2 Answers   TCS,


Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,


Could anyone give brief explanation bout datastage admin

0 Answers  


Pls tell me what is troubleshooting in datastage view?

1 Answers  






what r the sources u need to create the datastage?

1 Answers  


describe the Steps to confiure a Qlogic switch

0 Answers   IBM,


What is use Array size in datastage

0 Answers  


I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


what is set mapping in datastage??

2 Answers   ADP,


What is the difference between account and directory options ?

0 Answers  


Categories