Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of remove the duplicate records?
- 3 Answers
- 11656 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
Difference between in process and inter process?
How to find value from a column in a dataset?
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...
Define repository tables in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is staging variable?
Define APT_CONFIG in Datastage?
What are the components of datastage?
how can we create rank using datastage?what is the meaning of rank?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the various kinds of the hash file?
What is size of a transaction and an array means in a datastage?
What are transforms and what is the differenece between routines and transforms?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Define project in datastage?
