Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

787

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

853

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

710

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

921

How do you remove duplicate records in informatica?

1 969

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

1541

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

903

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.

1025

Explain in detail scd type 2 through mapping.

817

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

932

Explain the different kinds of facts.

724

How do you load only null records into target?

929

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

774

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

751

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

872


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by target load plan?

723


What do you mean by filter transformation?

729


Can we create a Integration service without a Repository service and vice versa?

957


What is the difference between router and filter?

818


can u any challenge your project?

1772






Can we create a node as a gateway node and the same node can be assigned to a grid?

832


What is a router transformation?

802


What is status code in informatica?

765


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2303


What is the need of an ETL tool?

818


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1824


what is $$$$?

1908


Differentiate between source qualifier and filter transformation?

1262


How you can differentiate between connected lookup and unconnected lookup?

804


What is a shortcut and copy in Informatica and how two are different with each other?

907