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?

1048

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.

1708

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.

1094

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?

1115

Post New Informatica Questions

Un-Answered Questions { Informatica }

server hot-ws270 is connect to Repository B. What does it mean?

2565

Explain transaction control transformation in informatica

1268

What are the new features of Power Center 5.0?

1779

What is a code page?

1177

What are the various types of transformation?

1179

Differentiate between sessions and batches?

1018

As union transformation gives UNION ALL output, how you will get the UNION output?

1108

What is the status code in stored procedure transformation?

1182

What will be the approach?

979

What are the tasks that can be performed using sq?

1091

How to generate or load values in to the target table based on a column value using informatica etl tool.

1074

What is status code in informatica?

1020

What is a rank transform?

1086

Which files are created during the session rums by informatics server?

1180

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2744

For More Un-Answered { Informatica } Questions Click Here