source file is having 5 records while moving into target it
want to be 10 records
- 4 Answers
- 9757 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how to load meta data
How the ipc stage work?
Main Function of the Staging area in DWH ?
how to get the unique records on multiple columns by using sequential file stage only
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
how to call sequential generator in datastage?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
how to change left and right links in join stage?
how can u handle null values in transformer stage.
What is the use of surrogate key stage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Teradata 
