how CAN we remove duplicates in dataset?
Answers were Sorted based on User's Feedback
Answer / disney
In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset
| Is This Answer Correct ? | 25 Yes | 0 No |
Answer / markonda
by using remove duplicate stage we can remove duplicates
| Is This Answer Correct ? | 3 Yes | 6 No |
What are the processing stages?
How can u write exception handling in seq file????
What is Cleanup Resources and when do you use it?
What is the difference between Datastage 7.5 and 7.0?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Difference between ‘validated ok’ and ‘compiled’ in data stage?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
What are the types of containers in datastage?
how to abort the job its matain duplicates?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
What is the importance of the exception activity in datastage?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....