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
Define Data Stage?
What is the difference between Datastage 7.5 and 7.0?
Define repository tables in datastage?
What is ibm datastage?
How a server job can be converted to a parallel job?
why do u need the IOS upgradation in a FC switch
What is the roundrobin collector?
Could anyone give brief explanation bout datastage admin
What are the repository tables in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What can we do with datastage director?
What are the features of datastage flow designer?
Define oconv () and iconv () functions in datastage?
Define data aggregation?