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?

1030

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

1049

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

1110

What is dimensional table? Explain the different dimensions.

1110

What are the types of caches in lookup?

975

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

917

Differentiate between router and filter transformation?

952

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.

1628

What are the differences between oltp and olap?

921

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

888

Differentiate between reusable transformation and mapplet.

1028

Why update strategy and union transformations are active?

989

What is meant by target load plan?

914

How to join three sources using joiner?

1028

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

1055

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the format of informatica objects in a repository?

973

What are the informatica performance improvement tips

1017

How do you set a varible in incremental aggregation

1826

permutations of mapplet

2454

Explain sessions?

979

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

978

How to generate sequence numbers without using the sequence generator transformation?

1113

How many ways a relational source definition can be updated and what are they?

952

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

949

What is union transformation?

907

Clarify the utilization of aggregator cache record?

943

whats the logic to load the lower level of granularity of data to fact table.

2206

Enlist the various types of transformations.

952

Is it possible to use a client with different version than that of its Informatica server?

1075

What are the new features of informatica 9.x at the developer level?

985

For More Un-Answered { Informatica } Questions Click Here