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 |
how to identifie,is it innerjoin,leftouter join in lookup?
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
What steps should be taken to improve Datastage jobs?
How and where you used hash file?
why do we need a datawarehouse when we have databases to store data?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
How to move data set from one server to other?what are the steps to follow to do this?
What are the functionalities of link partitioner and link collector?
CHANGE CAPTURE
When we will go for Data elements?