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
- 1 Answers
- 4268 Views
- I also Faced
- E-Mail Answers
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 |
How to convert alpha Numeric values to alpha using functions?
Define repository tables in datastage?
what is repositery?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
What is datastage engine?
i have flat file and using unix how can i generate sequence number into targer?
how to closeing records after 10,000 records come?
how to find no.of records in sequntial file itself?
What is the process of killing a job in datastage?
Define Merge?
what is A Datastage?
what is a nodemap constraint
Teradata 
