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
- 20566 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
What is the roundrobin collector?
What are sequencers?
Explain how a source file is populated?
Why do we use link partitioner and link collector in datastage?
What are the areas of application?
What is use Array size in datastage
What is the purpose of pivot stage and types of containers in datastage
How do you run datastage job from the command line?
What is the difference between operational data stage (ods) and data warehouse?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are routines in datastage? Enlist various types of routines.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are stage variables?
what is repositery?
Why fact table is in normal form?
