how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / rkumar.etl
use aggregator transformation and group by all ports and
create one port for checking count...and pass the results
accordingly to target tables.
| Is This Answer Correct ? | 24 Yes | 3 No |
Post New Answer View All Answers
What will be the approach?
What is dimensional table? Explain the different dimensions.
What is the difference between router and filter?
How to do the error handling of if ur source is flatfiles?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is informatica metadata and where is it stored?
Can we override a native sql query within informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a code page?
What is fact table? Explain the different kinds of facts.
explan ur project architecture?
What are the limitations of joiner transformation?
What do you mean by enterprise data warehousing?
What is persistent lookup cache?
What is a pre-defined event and user-defined event?