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?

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

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

What is dimensional table? Explain the different dimensions.

What are the types of caches in lookup?

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

Differentiate between router and filter transformation?

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.

What are the differences between oltp and olap?

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

Differentiate between reusable transformation and mapplet.

Why update strategy and union transformations are active?

What is meant by target load plan?

How to join three sources using joiner?

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

Post New Informatica Questions

Un-Answered Questions { Informatica }

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

700

Whats the difference between informatica powercenter server, repositoryserver and repository?

What is meant by a domain?

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

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

6792

What are connected or unconnected transformations?

112

Which version configuration tool used in ur project?

2187

What is informatica etl tool?

EXL informatica Questions

332

How can you differentiate between powercenter and power map?

Can we create a Integration service without a Repository service and vice versa?

101

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1339

update strategy transformation in informatica

Which are the different editions of informatica powercenter that are available?

What you know about transaction control transformation?

For More Un-Answered { Informatica } Questions Click Here