Informatica Interview Questions
Questions Answers Views Company eMail

Quickly characterize reusable change?

886

What do you mean by channel change?

737

What are the measure objects?

876

What are the different types of transformation available in informatica.

811

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

754

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

817

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

858

Explain the different dimensions.

723

Differentiate between source qualifier and filter transformation?

1262

Explain scd type 3 through mapping.

758

What is dimensional table?

784

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

1318

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

870

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.

848

Explain in detail about scd type 1 through mapping.

810


Post New Informatica Questions

Un-Answered Questions { Informatica }

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

775


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1840


define galaxy repository in informatica

1916


Explain transaction control transformation in informatica

1001


What is incremental aggregation?

789






Briefly describe lookup transformation?

768


Suppose we do not group by on any ports of the aggregator what will be the output?

791


What are the advantages of using informatica as an etl tool over teradata?

757


How many input parameters can exist in an unconnected lookup?

1251


What are the guidelines to be followed while using union transformation?

853


Repository user profiles

1551


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2066


What are the settings that you use to configure the joiner transformation?

791


How can informatica be used for an organization?

848


What is the procedure for creating independent data marts from informatica 7.1?

754