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
- 20257 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
How do you register plug-ins?
What are datastage sequences?
Can you explain repository tables in datastage?
Differentiate between data file and descriptor file?
What are the different types of lookups in datastage?
How to read the length of word in unix?
How do you generate sequence number in datastage?
What are iconv and oconv?
Could anyone give brief explanation bout datastage admin
How do you import and export the datastage jobs?
whom do you report?
How many types of hash files are there?
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
How many types of sorting methods are available in datastage?
What are the main features of datastage?
