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
Answer Posted / sreenu
Using aggregation and filter stage,
In aggregation stage we calculate the count of incoming
records and in filter we use count<>1 for output1, count=1 for
output2...
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
What is the difference between account and directory options ?
client know skid info?
What is the difference between odbc and drs stage?
Define Merge?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are some prerequisites for datastage?
What a datastage macro?
Differentiate between hash file and sequential file?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How will you move hashed file from one location to another location?
Describe link sort?
What is the difference between passive stage and active stage?
What is the difference between server job and parallel jobs?
in oracle target stage when we use load option and when we use upsert option?