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 3990

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

1 5921

What is a test load?

1 4010

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 6614

What is mapplet and a reusable transformation?

2 5044

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 6393

When will you use SQL override in a lookup transformation?

1 5802

Two different admin users created for repository are ______ and_______

1 4377

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

2 7547

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

1 4720

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2421

difference between repository database and repository service?

1151

What is deployment group?

1215

What is Session and Batches?

1108

wat are deployement groups in informatica, how it will be used for developers

1719

write a query to retrieve the latest records from the table sorted by version(scd)

1068

What is meant by active and passive transformation?

1125

Performance tuning( what you did in performance tuning)

1987

How do you set a varible in incremental aggregation

1891

What is aggregate cache in aggregator transformation?

1145

What are the main features of Oracle 8i with context to datawarehouse?

2112

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167

What are the different versions of informatica?

1275

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1126

For More Un-Answered { Informatica } Questions Click Here