source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235
Answer Posted / s
agg-->filter-->trg2
^ |
| v
seq-->copy-->join-->trg1
agg:countrows
join:innerjoin
filter:count=1
:count>1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the differentiate between data file and descriptor file?
What are sequencers?
Explain Quality stage?
what are the errors,warnings in datastage
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the various kinds of containers available in datastage?
What is the sortmerge collector?
What is the purpose of pivot stage and types of containers in 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
What are the stages in datastage?
How the ipc stage work?
What is datastage engine?
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 is datastage?
On which interface you will be working as a developer?