How do you remove duplicate records in informatica?
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 |
What is complex mapping?
what is galaxy repository?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a router transformation?
How to elaborate powercenter integration service?
In development project what is the process to follow for an etl developer from day1
How will you combine 3 different sources with a single source?
how do u use sequence created in oracle in informatica? Explain with an simple example
What is the Difference between DSS & OLTP?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
waht is dataware house