Best Top Informatica Interview Questions you should prepare

Top Informatica Interview Questions on Lookup Transformation

    

Please explain the the difference between connected unconnected lookup ?
In which case would you prefer an unconnected lookup over connected lookup?
What types of cache is created on look up. Explain all types of cache.
In which scenario would you prefer persistent cache of the lookup?What property can be used for persistent cache if the look up table changes once in a while?
Explain whats is dynamic lookup configurations and how it works ?

Visit Top 5 Most Common Interview questions in Informatica

Top Informatica Interview Questions on Normalizer

What are GCID and GK fields in Normalizer?
What is the importance of occurs property in Normalizer?
How will you convert one row in two rows (normalizer) ?

Top Informatica Interview Questions on Aggregator

If there are no group by ports selected in aggregator what will be the output if 10 rows are passed as input?

Top Informatica Interview Questions on Sorter

In SORTER if you select distinct then will it sort on base of the key defined or on all the columns ?

Top Informatica Interview Questions on Update Strategy

Have you used update strategy transformation ? Explain ?
Explain SCD Type 2 type mapping ?
Do you know MD5 function?

Top Informatica Interview Questions on Joiner

Explain JOINER transformation?
Which one is faster look up or joiner and why?

Top Informatica Interview Questions on Partitioning
Do you know Pushed down optimization? What are the limitations ?
Do you know Informatica partitioning ? How do you use them explain with examples.