Informatica Interview Questions
Questions Answers Views Company eMail

Write the unconnected lookup syntax?

62

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

67

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

76




What is dimensional table? Explain the different dimensions.

76

What are the types of caches in lookup?

69

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

68

Differentiate between router and filter transformation?

60

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.

90




What are the differences between oltp and olap?

66

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

70

Differentiate between reusable transformation and mapplet.

60

Why update strategy and union transformations are active?

70

What is meant by target load plan?

71

How to join three sources using joiner?

63

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

82


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?

93


What is meant by a domain?

79


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

85


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?

68


EXL informatica Questions

332


How can you differentiate between powercenter and power map?

75


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

99


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

70


What you know about transaction control transformation?

78