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
- 20977 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
First use the seq filestage then use the copy stage after
the copy stage one link is going to agregator stage there we
will calculate the count of records after the agregator
stage use filter stage for finding uniq records then those
records are connected to the lookup as a reference link. the
main link for lookup is comming from copy stage. Then
matching records are uniq else duplicate.
Agre--->filter
| |
Seq--->copy---->Lookup---->uniq
|
|
duplicate.
In agregator use count rows.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
how many rows sorted in sort stage by default in server jobs
What is a merge?
What all are the different way to run a job?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is difference between join, merge and lookup stage?
Does datastage support slowly changing dimensions ?
Define Data Stage?
How many types of hash files are there?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between an operational datastage and a data warehouse?
in oracle target stage when we use load option and when we use upsert option?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
