Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

what is lookup ?

7 16631

what is the architecture of any Data warehousing project?

IBM,

5 20911

what is the flow?

1 8495

How to load time dimension?

Ford,

1 15767

In update strategy target table or flat file which gives more performance ? why?

7 26293

How do you create single lookup transformation using multiple tables?

TCS,

6 44634

Why touse stored procedure in ETL Application?

2 11924

How to improve the performance of Aggregate transformation?

Dmss,

3 14326

What is critical mapping?

2 11396

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 19919

How to view and Generate Metadata Reports?

1 7836

what is difference between COM & DCOM?

Satyam,

1 11212

what is the gap analysis?

1 9521

How to recover sessions in concurrent batches?

3 15748

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 25305

Post New Informatica Questions

Un-Answered Questions { Informatica }

permutations of mapplet

2512

Explain the features of connected and unconnected lookup.

935

What is a node in Informatica?

1045

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1905

What is a shortcut and copy in Informatica and how two are different with each other?

1199

How many number of sessions can one group in batches?

1160

Differentiate between sessions and batches?

1021

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

What are the tuning techniques you applied during your last project

2027

What are the types of caches in lookup?

1052

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1907

Write the unconnected lookup syntax?

1084

Where is metadata stored?

1117

what is the size of your data warehousing?

2096

For More Un-Answered { Informatica } Questions Click Here