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

Informatica Interview Questions

Questions Answers Views Company eMail

Write the unconnected lookup syntax?

1084

Write the unconnected lookup syntax and how to return more than one column.

1110

How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

What is dimensional table? Explain the different dimensions.

1172

What are the types of caches in lookup?

1048

What are the types of caches in lookup? Explain them.

969

Differentiate between router and filter transformation?

1012

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

What are the differences between oltp and olap?

972

What are the types of schemas we have in data warehouse and what are the difference between them?

941

Differentiate between reusable transformation and mapplet.

1094

Why update strategy and union transformations are active?

1042

What is meant by target load plan?

973

How to join three sources using joiner?

1113

How do you update the records with or without using update strategy?

1114

Post New Informatica Questions

Un-Answered Questions { Informatica }

How you prepared reports for OLAP?

1595

What are active transformations.

1654

Can anyone tell me the new features in Informatica 9 Version?

2125

How to create a non-reusable instance of reusable transformations?

1131

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

How to extract sap data using informatica? What is abap? What are idocs?

1181

Explain in detail scd type 2 through mapping.

1041

Can you use flat files in Mapplets.

2649

What is the need of etl tools?

1120

How to do unit testing in informatica?

1171

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107

Describe expression transformation?

1123

Enlist the various types of transformations.

1057

What are the conditions needed to improve the performance of informatica aggregator transformation?

1093

For More Un-Answered { Informatica } Questions Click Here