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
- 20093 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 do you import and export the datastage jobs?
What are iconv and oconv?
What is the difference between orabulk and bcp stages?
Define Merge?
Differentiate between Join, Merge and Lookup stage?
How many types of sorting methods are available in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Explain entity, attribute and relationship in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the job parameters?
Define APT_CONFIG in Datastage?
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...
Where the datastage stored his repository?
How many types of hash files are there?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
