source file is having 5 records while moving into target it
want to be 10 records
- 4 Answers
- 10144 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 change left and right links in join stage?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What are operators in datastage?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
what is snow flack schema?
Define data aggregation?
WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?
how to unlock a locked job in datastage 8.0
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Which warehouse using in your datawarehouse
Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Teradata 
