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
- 16830 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate
1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to reverse the string using unix?
How will you move hashed file from one location to another location?
Name the third party tools that can be used in datastage?
How to perform incremental load in datastage?
What are the various kinds of containers available in datastage?
How many types of sorting methods are available in datastage?
What are the difference types of stages?
What could be a data source system?
What is the purpose of pivot stage and types of containers in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do you register plug-ins?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How do you start developing a datastage project?
What is the difference between datastage and datastage tx?
How do you reject records in a transformer?
