Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of remove the duplicate records?
- 3 Answers
- 11780 Views
- Caterpillar, I also Faced
- E-Mail Answers
Answer Posted / rohit babar
There are 3 ways by which we can remove the duplicate records
1. By using remove duplicate stage. We have control here on which record we want to remove it's first or last. There is option record to retain in remove duplicate stage where we select first or last option.
2. By using sort stage. there is option allow duplicate in sort stage. We set this option true when we want duplicate records & If we want unique records we set it to the false
3. By in-line sorting. In Partition tab of any stage when we select key base partition tech. then perform sort option will enable if we check this option next 2 option will enable which is stable & unique if we select stable that means we allow duplicate records & if we select unique that means we remove duplicate records and getting unique records
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is ibm datastage flow designer?
What are the various kinds of the hash file?
how to delete one row in target dataset
project Steps,hits, Project level HArd things,Solved methods?
Which algorithm you used for your hashfile?
how to write server Routine coding?
explain about citrix scheduling tool in datastage
What are the steps required to kill the job in Datastage?
What are the types of hashed files in data stage
How do you import and export the datastage jobs?
What are the processing stages?
What is difference between server jobs & parallel jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the areas of application?
whom do you report?
