Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

717

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

783

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

652

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

868

How do you remove duplicate records in informatica?

1 902

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

1467

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

826

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.

946

Explain in detail scd type 2 through mapping.

772

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

870

Explain the different kinds of facts.

673

How do you load only null records into target?

873

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

730

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

706

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

813


Post New Informatica Questions

Un-Answered Questions { Informatica }

How to implement security measures using repository manager?

725


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1917


How to extract sap data using informatica?

725


What are the new features of informatica 9.x in developer level?

678


How you know when to use a static cache and dynamic cache in lookup transformation?

1462






What are the popular informatica products?

749


Enlist the various types of transformations.

674


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1857


What are mapplets?

943


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1324


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1637


How do you set a varible in incremental aggregation

1580


Explain in detail scd type 2 through mapping.

772


What is a predefined event?

791


What is domain in terms of informatica?

674