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?

1080

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

1106

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

1163

What is dimensional table? Explain the different dimensions.

1168

What are the types of caches in lookup?

1046

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

969

Differentiate between router and filter transformation?

1007

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.

1698

What are the differences between oltp and olap?

969

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

939

Differentiate between reusable transformation and mapplet.

1086

Why update strategy and union transformations are active?

1038

What is meant by target load plan?

969

How to join three sources using joiner?

1100

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

1111

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain pushdown optimization $pushdownconfig parameter - informatica

1127

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2247

How do we call shell scripts from informatica?

1107

What is depict expression change?

1113

Explain Dataware house architecture .how data flow from intial to end?

2578

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4725

What are the types of presistent cache in look up tr.

2049

Briefly explain the aggregator transformation?

993

What are the static cache and dynamic cache in informatica?

1181

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

What is the fact table?

1060

What is the meaning of decode in informatica?

1118

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3861

can we override a native sql query within informatica? How do we do it?

1121

How do you change a non-reusable transformation to reusable transformation?

994

For More Un-Answered { Informatica } Questions Click Here