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 3988

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

1 5921

What is a test load?

1 4008

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

1 4763

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

3 6612

What is mapplet and a reusable transformation?

2 5043

How do you implement configuration management in Informatica?

1 3740

What are Business Components in Informatica?

1 4972

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

2395

COM components can be used in Informatica

2390

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

Wipro,

1 6388

When will you use SQL override in a lookup transformation?

1 5802

Two different admin users created for repository are ______ and_______

1 4373

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

2 7545

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

1 4719

Post New Informatica Questions

Un-Answered Questions { Informatica }

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1082

What is the format of informatica objects in a repository?

1019

What is InformaticaPowerCenter?

1136

Sequence generator, when you move from develoment to production how will you reset

2036

what are 3 tech challenges/ common issues you face?

2346

Separate from an archive server and a powerhouse?

962

Can we get 1st record through Informatica(without sequence number).

1479

Can u generate reports in Informatica?

1086

What are the components of the workflow manager?

1134

What is repository manager?

986

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

What happens when a session fails and you click on recover?

1120

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2120

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2720

What are the steps involved in the migration from older version to newer version of Informatica Server?

2106

For More Un-Answered { Informatica } Questions Click Here