Informatica Interview Questions asked in MNCs

What are the joiner caches?

What are the types of mapping in Getting Started Wizard?

What is a junk dimension

What is difference between cbl (constaint based commit) and target based commit?When we use
cbl?

What is metadata reporter?

What is the best way to show metadata(number of rows at source, target and each
transformation level, error related data) in a report format

What is the difference between summary filter and detail filter

What is the use of incremental aggregation? Explain me in brief with an example.

Where we are using lkp b/n source to stage or stage to target?

Why and where we are using factless fact table?

Can we create duplicate rows in star schema?

Explain Performance tuning in Informatica?

How can you say that union Transormation is Active transformation.

How do you setup a schedule for data loading from scratch?

How to delete duplicate rows in flat files source is any option in Informatica

How you will create header and footer in target using Informatica?

Mention the various test procedures to check for whether the data is loaded in the backend, performance of mapping, and quality of the data loaded in Informatica

What are the active and passive transforamtions?

What are the locks with respect to mappings? How do you manually lock or unlock the mappings
for changes?

What are the types of maping wizards that are to be provided in Informatica?

What is a look up function? What is default transformation for the look up function?

What is difference between COM & DCOM?

What is Micro Strategy? Why is it used for? Can any one explain in detail about it?

What is the daily data volume (in GB/records)? What is the size of the data extracted in the extraction process?

What is the difference between truncate and delete statements?

What is the use of Shared Folder?

Where we use Star Schema & where Snowflake?

Why can't we use normalizer transformation in mapplet?

Can we eliminate duplicate rows by using filter and router transformation ?if so explain me in
detail .

Explain pmcmd?

How can you stop a batch?

How do you test mapping and what is associate port?

How to do aggregation with out using AGGREGAROR Transformation ?

I created a new group and removed the Browse Repository privilege from the group. Why does
every user in the group still have that privilege?

My input is oracle and my target is flat file shall I load it? How?

People who read this, may find the below Interesting