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?

1062

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

1157

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

963

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

1240

How do you remove duplicate records in informatica?

1 1384

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

1869

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

1159

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.

1279

Explain in detail scd type 2 through mapping.

1041

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

1259

Explain the different kinds of facts.

981

How do you load only null records into target?

1216

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

1076

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

1014

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

1147

Post New Informatica Questions

Un-Answered Questions { Informatica }

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

What is the use of source qualifier?

1138

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1126

What are the various types of transformation?

1179

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395

What is option by which we can run all the sessions in a batch simultaneously?

1142

What is a router transformation?

1129

Write the unconnected lookup syntax?

1084

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2026

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

1119

What is meant by active and passive transformation?

1125

what is Active lock explain

2799

tell me 5 session failure in real time how can you solve that in your project?

2303

How to update source definition?

1087

For More Un-Answered { Informatica } Questions Click Here