Informatica interview questions – page 13

What is batch and describe about types of batches?

Difference between Rank and Dense Rank?

When do u we use dynamic cache and when do we use static cache in an connected and unconnected lookup transformation

What is aggregate cache in aggregator transforamtion?

What are the mapping paramaters and maping variables?

What is the difference between constraind base load ordering and target load plan

How can we join 3 database like Flat File, Oracle, Db2 in Informatrica..

Explain about perform recovery?

What are the diffrence between joiner transformation and source qualifier transformation?

What is change data capture?

Why and where we are using factless fact table?

What is the Rankindex in Ranktransformation?

Explain about Informatica server Architecture?

Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?

What are Aggregate transformation?

Can you start a session inside a batch idividually?

How can you improve session performance in aggregator transformation?

What is the maplet?

What are the new features in Informatica 5.0?

Is a fact table normalized or de-normalized?

What are the connected or unconnected transforamations?

What are the rank caches?

What is a transforamation?

What is Code Page Compatibility?

What is power center repository?

What are two types of processes that informatica runs the session?

Which transformation should you need while using the cobol sources as source defintions?

Which transformation should we use to normalize the COBOL and relational sources?

What are the different threads in DTM process?

What are the different types of Type2 dimension maping?