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
- 20247 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / shar
Hi guys
Here is the answer.
Seq-->copy--->Agg,--> Join ----->Filter -----> DS1
----------> -----> DS2
Explanation:
From seq stg to copy and
from copy send one link to aggregator for counting of rows
and other to join stage for Clubbing.
At join use input column to club. From join to filter and at
filter give conditions at where clause count = 1 output link
-0 and count =2 output link -1.
Finally use Datasets as targets DS1 and DS2.
Ok thats it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the features of datastage flow designer?
What are stage variables and constants?
Differentiate between validated and Compiled in the Datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Can you implement SCD2 using join, transformer and funnel stage?
What is size of a transaction and an array means in a datastage?
how can we create rank using datastage?what is the meaning of rank?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Lookup constraints
What is the sortmerge collector?
what is use of SDR function?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the main features of datastage?
Difference between sequential file and data set?
Define oconv () and iconv () functions in datastage?
