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

Informatica Interview Questions

Questions Answers Views Company eMail

What is hash partition?

2 8372

How can you define a transformation? What are different types of transformations in Informatica?

10 25201

What is query panel?

1 5529

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

ASM, TCS,

2 17067

What is difference between a connected look up and unconnected look up?

6 25513

What is staging area?

11 26571

What is data merging, data cleansing and sampling?

Satyam,

6 22661

What is up date strategy and what are the options for update strategy?

2 10258

Why do we use DSS database for OLAP tools?

2 6739

What is active and passive transformation?

10 40686

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 19615

How is Data Models Used in Practice?

1 5298

What is the difference between view and materialised view?

4 12908

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

IBM, Wipro,

2 21269

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38127

Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1278

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7328

What is the scenario which compels informatica server to reject files?

1017

How can we use mapping variables in informatica?

1011

What are the different components of powercenter?

996

 Informatica Checkpoints

3277

where to store informatica rejected data? How to extract the informatica rejected data?

960

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2063

Is it possible to define a single node as a Gateway node as well as worker node?

1067

What are the components of workflow manager?

1027

What is the status code in stored procedure transformation?

1130

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1233

what is song in infrmatica...?

2171

Whats there in global repository

1648

How to improve the performance of a session using sorter transformation?

1098

For More Un-Answered { Informatica } Questions Click Here