Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Quickly characterize reusable change?

938

What do you mean by channel change?

795

What are the measure objects?

941

What are the different types of transformation available in informatica.

866

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

820

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

886

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

915

Explain the different dimensions.

772

Differentiate between source qualifier and filter transformation?

1329

Explain scd type 3 through mapping.

796

What is dimensional table?

855

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

1388

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

937

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.

923

Explain in detail about scd type 1 through mapping.

871

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain lookup transformation in informatica

864

How is union transformation utilized?

835

Describe an informatica powercenter?

836

r u done any partitions in ur project?

1619

What is parallel processing in informatica?

1359

While migrating the data from one environment to another environment how would you manage the connections?

915

What is the sequence generator transformation in informatica?

911

Whats there in global repository

1487

What is incremental aggregation?

869

Explain what is informatica metadata and where is it stored?

860

What is an aggregator transformation?

866

What is aggregator transformation in informatica?

773

How can you validate all mappings in the repository simultaneously?

1097

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1705

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

944

For More Un-Answered { Informatica } Questions Click Here