How do you remove duplicate values in datastage?



How do you remove duplicate values in datastage?..

Answer / Km Neeshu Chahal

"To remove duplicates, you can use Distinct or Aggregate transforms in DataStage. Both of these transformations help eliminate repetitive records based on specified columns."n

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is datastage?

1 Answers  


Does datastage support slowly changing dimensions ?

1 Answers  


How to find value from a column in a dataset?

1 Answers   TIAA CREF,


why we use hash file for lookup?

5 Answers  


Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,


how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,


How you can fix the truncated data error in datastage?

1 Answers  


What is the sortmerge collector?

1 Answers  


How can we do null handling in sequential files

3 Answers   Reliance,


I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,


how to write server Routine coding?

1 Answers   Eric,


HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,


Categories