how many types of remove the duplicate records?
- 3 Answers
- 10132 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
What is the difference between account and directory options ?
What all the types of jobs you developed?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Difference between data warehousing and olap?
What is oci?
What are the types of hashed files in data stage
Enlist various types of routines in datastage.
sed,awk,head
What are the differences between datastage and informatica?
What is the roundrobin collector?
What is datastage engine?
I have a few records just I want to store data in to targets cycling way how?
what is repositery?
what is the use of surogate key in datastage
What are the types of containers in datastage?
