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
- 20096 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 ibm datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the areas of application?
Name the third party tools that can be used in datastage?
Difference between server jobs & parallel jobs?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Whats difference betweeen operational data stage (ods) and data warehouse?
Can we use target hash file as a lookup ?
why do u need the IOS upgradation in a FC switch
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What can we do with datastage director?
What are the different types of lookups in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
