Interested to Buy Any Domain ? << Click Here >> for more details...
i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
- 13 Answers
- 20264 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Unfortunately, I didn't got the logic behind the YOUR answer.
According your logic: from aggregator stage: the output is this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985
If you join these two links then:
251
251
456
456
951
985
251,2
456,2
951,1
985,1
Then your are specifying that count=1 then you get the unique records.
in another link count<>1 means YOU get 251
456
Unfortunately this is not our desired out put, our out put is: 251
251
456
456
SO, YOUR LOGIC IS NOT ACCEPTABLE. TRY TO THINK FOR DESIRED OUTPUT !!!!
in order to get the desired out put i using the lookup-stage
in lookup i am going to lookup the out put from filter stage which is 951,985 with main data there i will specify the condition as reject:
so YOU will get the desired output!!!!!
If you can prove the above logic is wrong send me the mail!!!!
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Differentiate between Join, Merge and Lookup stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Can you explain tagbatch restructure operator?
What is "fatal error/rdbms code 3996" error?
Define data aggregation?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Why do we use link partitioner and link collector in datastage?
Which commands are used to import and export the datastage jobs?
What is the purpose of pivot stage?
How a source file is populated?
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 benefits of datastage?
What are transforms and what is the differenece between routines and transforms?
Difference between sequential file and data set?
What is active and passive stage?
