how many types of remove the duplicate records?
- 3 Answers
- 10813 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 the difference between Datastage 7.5 and 7.0?
Explain datastage architecture?
I have a few records just I want to store data in to targets cycling way how?
how many rows sorted in sort stage by default in server jobs
What are the types of jobs we have in datastage?
How to perform incremental load in datastage?
How will you move hashed file from one location to another location?
What is apt_config in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Can you explain engine tier in information server?
Can you explain players in datastage?
What are the job parameters?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to export or import the jobs in .ISX file
