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 4067

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

1 6009

What is a test load?

1 4114

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

1 4845

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

3 6752

What is mapplet and a reusable transformation?

2 5135

How do you implement configuration management in Informatica?

1 3818

What are Business Components in Informatica?

1 5061

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

2445

COM components can be used in Informatica

2456

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

Wipro,

1 6496

When will you use SQL override in a lookup transformation?

1 5868

Two different admin users created for repository are ______ and_______

1 4449

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

2 7641

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

1 4802

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain lookup transformation is active in informatica

1151

What is flashback table ? Advance thanks

1999

What is rank transform?

1061

Explain what are the different versions of informatica?

1149

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

How to create or import flat file definition in to the warehouse designer?

1137

Please let me know how to make encryption and decryption with example?

1950

tell me about your project functionality

2383

What is domain in terms of informatica?

1063

What's the layout of parameter file (what does a parameter file contain?)?

2439

Define Pmrep command?

1117

Design a mapping to load the cumulative sum of salaries of employees into target table?

1557

What are the differences between oltp and olap?

1018

What is blocking transformation?

1191

What is the difference between Active and Passive transformation?

1225

For More Un-Answered { Informatica } Questions Click Here