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 3976

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

1 5915

What is a test load?

1 4006

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 6599

What is mapplet and a reusable transformation?

2 5037

How do you implement configuration management in Informatica?

1 3738

What are Business Components in Informatica?

1 4963

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

2391

COM components can be used in Informatica

2385

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

Wipro,

1 6378

When will you use SQL override in a lookup transformation?

1 5788

Two different admin users created for repository are ______ and_______

1 4365

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

2 7537

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

1 4715

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is joiner transformation in informatica?

1043

What is the commit type if you have a transaction control transformation in the mapping?

1030

What is the difference between a repository server and a powerhouse?

1504

What is meant by lookup transformation?

1099

Define pmcmd command?

1037

During the running session, output files are created by informatica server. Enlist few of them.

976

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2031

What is union transformation in informatica?

1144

can u give example for factless fact table

6640

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2353

What is data transformation manager process?

1151

Is stop and abort are same in informatica?

995

Explain about cumulative Sum or moving sum?

1037

What is flashback table ? Advance thanks

1930

How many number of sessions can one group in batches?

1157

For More Un-Answered { Informatica } Questions Click Here