Informatica FAQs Interview Questions

Tags: Informatica FAQs Interview Questions,Informatica Technical Interview Questions,
Informatica Interview Questions

What is a source qualifier? What is meant by Query Override?

What is DTM session?

What is QTP in Data Warehousing?

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

What is the hierarchies in DWH?

What is user defined Transformation?

Why we use partitioning the session in informatica?

Can you copy the session to a different folder or repository?

How can we access MAINFRAME tables in INFORMATICA as a source ?

How do we load data by using period dimension?

How is the union transformation active transformation?

How to implement de-normalization concept in Informatica Mappings?

If you are using aggregator transformation in your mapping at that time your source contain
dimension or fact?

Using unconnected lookup how we you remove nulls n duplicates?

What are the data movement modes in informatcia?

What are the properties should be notified when we connect the flat file source definition to relational database target definition?

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

What is a surrogate key?

What is Dynamic Data Store?

What is rank transformation?where can we use this transformation?

What is the difference between constraints based load ordering and target load plan?

What is the limit to the number of sources and targets you can have in a mapping

What is version controlling?

Why we use stored procedure transformation?

Can you explain one critical mapping?2.performance issue which one is better? whether connected lookup transformation or unconnected one?

How can we delete duplicate rows from flat files ?

How do we load from PL/SQL script into Informatica mapping?

How many Data marts are there in your project?

How to import oracle sequence into Informatica.

If you are workflow is running slow in Informatica. Where do you start trouble shooting and what are the steps you follow

We are using Update Strategy Transformation in mapping How can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.

What is a time dimension? give an example.

What is dynamic insert?

What is re-dimension?

What is the difference between dynamic and static lookup.

People who read this, may find the below Interesting