Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 10359

what is the architecture of any Data warehousing project?

IBM,

5 14924

what is the flow?

1 5320

How to load time dimension?

Ford,

1 12336

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

7 19016

How do you create single lookup transformation using multiple tables?

TCS,

6 32137

Why touse stored procedure in ETL Application?

2 8260

How to improve the performance of Aggregate transformation?

Dmss,

3 9979

What is critical mapping?

2 7967

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

Accenture,

1 15333

How to view and Generate Metadata Reports?

1 5420

what is difference between COM & DCOM?

Satyam,

1 8670

what is the gap analysis?

1 6783

How to recover sessions in concurrent batches?

3 11853

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

TCS,

3 20172


Post New Informatica Questions






Un-Answered Questions { Informatica }

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

1612


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

5399


What are the new features of informatica 9.x developer?

81


what are factless facts? And in which scenario will you use such kinds of fact tables.

788


What is workflow manager?

76






can we override a native sql query within informatica? How do we do it?

83


Explain what are the different versions of informatica?

91


What is Data Caches size?

114


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

874


Is there any way to read the ms excel datas directly into informatica?

94


What are the settings that you use to configure the joiner transformation?

113


What is standalone command task?

108


what is the Default Source Option For Update Strategy Transformation?

117


if we have a delimiters at unwanted places in a flat file how can we over come those.

1034


How to do unit testing in informatica? How to load data in informatica ?

78