Database Administrator (dba) interview questions – page 17

What is batch and describe about types of batches?

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 is the difference between constraind base load ordering and target load plan

Explain about perform recovery?

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

Why and where we are using factless fact table?

What is the Rankindex in Ranktransformation?

Have you good knowledge on Java.

Explain about Informatica server Architecture?

What are Dedicated and Pool Threads?

What are Aggregate transformation?

Can you start a session inside a batch idividually?

How can you improve session performance in aggregator transformation?

What are the new features in Informatica 5.0?

What are the rank caches?

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?

In a sequential batch can you run the session if previous session fails?

What are the mapings that we use for slowly changing dimension table?

What is meant by aggregate fact table and where is it used?

How to import oracle sequence into Informatica.

How can you say that union Transormation is Active transformation.

What is hash table informatica?

Why we use lookup transformations?

What are the 2 sqlcodes that are returned? ?