Informatica Interview Questions
Questions Answers Views Company eMail

Quickly characterize reusable change?

670

What do you mean by channel change?

525

What are the measure objects?

641

What are the different types of transformation available in informatica.

614

Explain what are the different types of transformation available in informatica.

553

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

594

How to do unit testing in informatica? How to load data in informatica ?

633

Explain the different dimensions.

536

Differentiate between source qualifier and filter transformation?

976

Explain scd type 3 through mapping.

567

What is dimensional table?

609

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

989

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

615

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

617

Explain in detail about scd type 1 through mapping.

566


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between stop and abort in informatica

646


Make a note of the quantity vaults made in informatica?

539


How to configure mapping in informatica?

663


Define mapping and session?

575


Explain the scenario which compels informatica server to reject files?

640






is it possible to index the data in cache of lkp transformation ?

1509


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 ?

1169


Explain direct and indirect flat file loading (source file type) - informatica

809


What is a passive transformation?

630


What is intricate mapping?

573


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1058


What are multi-group transformations?

550


How to load the data from a flat file into the target where the source flat file name changes daily?

564


How to generate sequence numbers without using the sequence generator transformation?

627


Explain sessions and how many types of sessions are there?

568