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
- 20542 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
Difference between server jobs & parallel jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what is ds administrator used for?
which r the connectors used in san?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How a routine is called in datastage job?
What are the various kinds of the hash file?
How do you start developing a datastage project?
How a server job can be converted to a parallel job?
What is difference between join, merge and lookup stage?
State the difference between an operational datastage and a data warehouse?
What are transforms and what is the differenece between routines and transforms?
What is the difference between in process and inter process?
What are stage variables, derivations and constants?
root tree will find which is server job and which is parallel job?
