Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of remove the duplicate records?
- 3 Answers
- 11667 Views
- Caterpillar, I also Faced
- E-Mail Answers
Answer Posted / soumya
1. Sort the Data using a key column then Use 3 transformer stage Variable
SV1 = Col1
SV2 = If SV1 = SV3 then 'DUP' else 'UNQ'
SV3 (Initial value = 0)
In the constraint SV2 = 'DUP' or SV2 = 'UNQ'
2. Aggregater stage group by key col (col1) count the column
then a filter stage use count col > 1.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
If you want to use the same piece of code in different jobs, how will you achieve it?
What is ibm datastage flow designer?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between validated and compiled in the datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the purpose of pivot stage and types of containers in datastage
What are the primary usages of datastage tool?
table actions available in oracle connector?
What a datastage macro?
what is ds administrator used for?
Where do you see different stages in the designer?
Describe stream connector?
how to sort two columns in single job in datastage.
