Eliminating of duplicate records without using dynamic lookups
Answer Posted / murthy
use distinct at sql override,use agrgregator etc
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how do u extract data from different data sources explain with an example?
What is a materialized view log?
What is etl process? How many steps etl contains?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is data modeling?
What is cube grouping?
Can u access a repository created in previous version of Informatica?
Explain different types of partitioning?
How can we use external procedural logic in informatica?
Mention few test cases and explain them?
What are the ETL Testing Operations?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
How many types of transformations supported by sorted input?
flat filevalidation in informatica
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.