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 |
What is datastage?
Does datastage support slowly changing dimensions ?
How to find value from a column in a dataset?
why we use hash file for lookup?
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
how can you generate sequence number using only the sequential file stage?
How you can fix the truncated data error in datastage?
What is the sortmerge collector?
How can we do null handling in sequential files
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
how to write server Routine coding?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?