Interested to Buy Any Domain ? << Click Here >> for more details...
how many types of remove the duplicate records?
- 3 Answers
- 11672 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 are the components of ascential data stage?
how to implement scd2 in datastage 7.5 with lookup stage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are stage variables, derivations and constants?
How will you move hashed file from one location to another location?
If you want to use the same piece of code in different jobs, how will you achieve it?
explain about citrix scheduling tool in datastage
How many types of views are there in a datastage director?
Why do we use exception activity in Datastage?
what is the difference between == and eq in UNIX shell scripting?
What are the main features of datastage?
whom do you report?
Explain ibm infosphere information server and highlight its main features?
What are the steps required to kill the job in Datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
