Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10059 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / keyrun
Hi, There are many ways to delete the duplicates!
By Using the following Transformations you can delete the Duplicates:
Source Qualifier: Use SQ and check 'Distinct' property (If the Source is Relational)
Sorter: Use sorter and in Properties tab Check 'Distinct'(If the Source is Flat File)
Aggregator: Use Aggregator & Group by on the key port.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Define pmcmd command?
Can u generate reports in Informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
design of staging area?
differences between service based and product based?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the new features of Power Center 5.0?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
can we override a native sql query within informatica? How do we do it?
tell me the rules and responsblites in our project(my project is development)
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
To import the flat file definition into the designer where should the flat file be placed?
Explain lookup transformation source types in informatica
Informatica Checkpoints
