Interested to Buy Any Domain ? << Click Here >> for more details...
How do you remove duplicate records in informatica?
- 1 Answers
- 1296 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Reusable transformation and shortcut differences
How to open an older version of an object in the workspace?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain the different kinds of facts.
Difference between Data and Index Caches?
What is primary and backup node?
What is data movement mode in Informatica and difference between them?
What does reusable transformation mean?
Can we override a native sql query within informatica?
How many ways are there to create ports?
Repository user profiles
Describe the impact of several join conditions and join order in a joiner transformation?
What the difference is between a database, a data warehouse and a data mart?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what are factless facts? And in which scenario will you use such kinds of fact tables.
