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
- 20645 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
What is the use of datastage designer?
describe the Steps to confiure a Qlogic switch
how many rows sorted in sort stage by default in server jobs
How do y read Sequential file from job control?
What is process model?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the primary usages of datastage tool?
Name the different sorting methods in datastage.
Distinguish between informatica & datastage. Which one would you choose and why?
Why we use surrogate key?
whom do you report?
Can you explain repository tables in datastage?
What a datastage macro?
