Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

1137

How do you convert single row from source into three rows into target?

1216

What are the types of schemas we have in data warehouse.

1008

Why update strategy and union transformations are active? Explain with examples.

1288

How do you remove duplicate records in informatica?

1 1459

How do you load alternate records into different tables through mapping flow?

1929

How do you load first and last records into target table?

1215

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1341

Explain in detail scd type 2 through mapping.

1092

How do you load unique records into one target table and duplicate records into a different target table?

1321

Explain the different kinds of facts.

1026

How do you load only null records into target?

1257

What is fact table? Explain the different kinds of facts.

1129

How many ways are there to do 'remove duplicate records in informatica'?

1067

How to join three sources using joiner? Explain though mapping flow.

1193

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly define reusable transformation?

1186

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

1118

Can you generate sequence numbers without using the sequence generator transformation?

1164

How to configure mapping in informatica?

1226

Mention a few design and development best practices for informatica?

1047

what are 3 tech challenges/ common issues you face?

2397

What is mapplet in informatica?

1130

What are session parameters ? How do you set them?

1901

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030

Do you find any difficulty while working with flat files as source and target?

1152

Define enterprise data warehousing?

1257

Under which circumstances, informatica server creates reject files?

1142

When do you use sql override in a lookup transformation?

1143

Which version configuration tool used in ur project?

3324

Can u generate reports in Informatica?

1145

For More Un-Answered { Informatica } Questions Click Here