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

Informatica Interview Questions

Questions Answers Views Company eMail

Explain the flow of data in Iinformatica?

1 9829

What are the new features of informatica 7.1?

2 7369

What are teh different tasks that can be created in workflow manager?

NIIT,

1 10053

What is the functionality of update strategy?

2 9258

Name 4 output files that informatica server creates during session running?

1 13614

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 15878

What are limitations of joiner transformation?

Exilant, TCS,

2 21226

can we generate reports in informatica ? How?

3 21868

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 7331

How can we eliminate duplicate rows from flatfile,explain?

3 11855

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 7264

AT the max how many transformations and mapplets can we use in a mapping ?

Cap Gemini, Cognizant,

1 17307

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 30842

What is the difference between OLTP and ODS?

4 27802

What is status code?

2 7127

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is different between the data warehouse and data mart?

1063

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282

What is workflow? What are the components of workflow manager?

1177

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1124

explain about unit testing? in real time?

2205

Implementation methodology

1710

how tokens will generate?

2204

How do you handle two sessions in Informatica

1164

What is union transformation in informatica?

1146

What is Session and Batches?

1108

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

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167

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

1907

What are the measure objects?

1202

What are the tuning techniques you applied during your last project

2024

For More Un-Answered { Informatica } Questions Click Here