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?

992

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

1090

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

893

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

1172

How do you remove duplicate records in informatica?

1 1300

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

1801

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

1098

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.

1219

Explain in detail scd type 2 through mapping.

986

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

1162

Explain the different kinds of facts.

933

How do you load only null records into target?

1140

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

1009

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

953

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

1089

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many ways are there to create ports?

1234

Partition, what happens if the specified key range is shorter and longer

2432

What are the advantages of informatica?

956

What is flashback table ? Advance thanks

1871

What do you understand by term role-playing dimension?

982

What is a connected transformation?

1046

Explain lookup transformation source types in informatica

1039

What is the difference between informatics 7x and 8x and what is latest version?

1022

What is the use of transformation?

944

Whats there in global repository

1641

What is workflow? What are the components of workflow manager?

1118

What is the way to execute pl/sql script using informatica mapping?

1507

Difference between Target-based loading and constraint-based loading?

943

What does command task mean?

1062

What are the different components of powercenter?

986

For More Un-Answered { Informatica } Questions Click Here