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. 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 |
What are routines in datastage?
how to export or import the jobs in .ISX file
What is the difference between Datastage 7.5 and 7.0?
how do u capture duplicates through sort & transformer
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the difference types of stages?
Define project in datastage?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
why do u need the IOS upgradation in a FC switch
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Can you explain kafka connector?
Why we need datasets ratherthan sequential files?