4)
source target
c1 c1 c2 c3
c2 c4 c4 c5
c3 c6 c7
c4
c5
c6
c7
please send me answer this question my mail
Answer Posted / subhash
1. SRC---->TFM---->TGT1,TGT2,TGT#
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
C1 1
C2 2
C3 3
c4 4
c5 5
c6 6
c7 7
in TFM,
put below condition for each target link.
TGT1--->MOD(ROWNUM,3)=1
TGT2--->MOD(ROWNUM,3)=2
TGT3--->MOD(ROWNUM,3)=0
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the partitioning techniques available in link partitioner?
What are the primary usages of datastage tool?
Why do we use link partitioner and link collector in datastage?
What all the types of jobs you developed?
Differentiate between operational datastage (ods) and data warehouse?
What is a datastage job?
How do you reject records in a transformer?
What is the method of removing duplicates, without the remove duplicate stage?
Define Data Stage?
What are the features of datastage flow designer?
What are datastage sequences?
What are sequencers?
What is oci?
How to perform incremental load in datastage?
What is job control?