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
- 20644 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
How one source columns or rows to be loaded in to two different tables?
Have you used Unstructured data?
What is a ds designer?
whom do you report?
What is the difference between in process and inter process?
How to read multiple files using a single datastage job if files have the same metadata?
what is the use of surogate key in datastage
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Explain datastage architecture?
what is flow of project?
What is the use of hoursfromtime() function in transformer stage in datastage?
Where the datastage stored his repository?
How complex jobs are implemented in datstage to improve performance?
Name the third party tools that can be used in datastage?
What are datastage sequences?
