Informatica Interview Questions
Questions Answers Views Company eMail

Quickly characterize reusable change?

672

What do you mean by channel change?

528

What are the measure objects?

643

What are the different types of transformation available in informatica.

617

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

558

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

596

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

635

Explain the different dimensions.

540

Differentiate between source qualifier and filter transformation?

985

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?

993

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

617

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.

619

Explain in detail about scd type 1 through mapping.

572


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are multi-group transformations?

552


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1762


Explain incremental aggregation in informatica

640


What is dimensional table?

609


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

1602






what are the deliverables?in your project?

1637


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

527


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

664


What are the different types of transformation available in informatica.

617


What is target designer and target load order?

645


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 ?

1730


How we can create indexes after completing the loan process?

710


How are the sources and targets definitions imported in informatica designer?

661


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

622


What is intricate mapping?

574