source file is having 5 records while moving into target it
want to be 10 records
- 4 Answers
- 10136 Views
- IBM, I also Faced
- E-Mail Answers
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
What all the types of jobs you developed?
Why do we use link partitioner and link collector in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the difference between validated and compiled in the datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How many types of stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the important features of datastage?
What is size of a transaction and an array means in a datastage?
How to reverse the string using SQL?
Where do you see different stages in the designer?
How will you move hashed file from one location to another location?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Notification Activity
How you Implemented SCD Type 1 & Type 2 in your project?
