How do you remove duplicate records in informatica?
- 1 Answers
- 851 Views
- I also Faced
- E-Mail Answers
Answer / lahari
There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to delete the (flat file) data in the target table after loaded.
What is sorter transformation?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Why use shortcuts(Instead of making copies).
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
How to generate sequence numbers without using the sequence generator transformation?
How to merge First Name & Last Name?
What are the reusable transforamtions?
Can we create two repositories on same database instance in oracle?
Why we require dwh in particular projects?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Differentiate between reusable transformation and mapplet.
Teradata 
