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?

1049

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

970

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.

1709

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.

1095

Why update strategy and union transformations are active?

1042

What is meant by target load plan?

974

How to join three sources using joiner?

1115

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

1116

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain why we use partitioning the session in informatica?

1092

What is rank transform?

997

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

What is meant by LDAP users?

1209

What are data-driven sessions?

1208

What is lookup transformation?

1042

Why do we need informatica?

992

How to use procedural logic inside infromatica?

1236

Plz can any one say me how to get the informatica certification materials and dumps

2048

Different qualification between a related rotate toward the sky and isolates look upward?

986

What is rank index in rank transformation?

1080

Explain what are the different types of transformation available in informatica.

1149

how many types of dimensions are available in informatica?

1099

What is the function of union transformation?

1134

Separate from a database, an information bazaar, and an information stockroom?

1089

For More Un-Answered { Informatica } Questions Click Here