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

Informatica Interview Questions

Questions Answers Views Company eMail

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 3995

What is the difference between normal and bulk loading? Which one is recommended?

1 5923

What is a test load?

1 4015

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 4769

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 6618

What is mapplet and a reusable transformation?

2 5047

How do you implement configuration management in Informatica?

1 3748

What are Business Components in Informatica?

1 4976

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

COM components can be used in Informatica

2395

What is the advantage of persistent cache? When it should be used.

Wipro,

1 6397

When will you use SQL override in a lookup transformation?

1 5804

Two different admin users created for repository are ______ and_______

1 4381

Two Default User groups created in the repository are ____ and ______

2 7556

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 4723

Post New Informatica Questions

Un-Answered Questions { Informatica }

difference between repository database and repository service?

1156

What do you mean by blocking transformation?

1045

Plz can any one say me how to get the informatica certification materials and dumps

2050

Explain the different kinds of facts.

985

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1173

What are data-driven sessions?

1218

How do you migrate data from one environment to another?

1096

What could be the possible resons of locks by user?

1095

What is the use of an aggregator cache file?

1200

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2129

What is union transformation in informatica?

1147

What is a pre-defined event and user-defined event?

1040

Differentiate between joiner and lookup transformation?

1103

Explain the tuning lookup transformation - informatica

997

For More Un-Answered { Informatica } Questions Click Here