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

Informatica Interview Questions

Questions Answers Views Company eMail

why dimenstion tables are denormalized in nature ?

3 9594

What is the use of incremental aggregation?

2 10144

What is the procedure to load the fact table.Give in detail?

1 8858

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 63323

What is the difference between Normal load and Bulk load?

5 50977

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46795

what is a time dimension? give an example?

IBM,

2 12612

What are the reusable transforamtions?

1 5025

What is aggregate cache in aggregator transforamtion?

5 9835

What are the basic needs to join two sources in a source qualifier?

3 7315

In which circumstances that informatica server creates Reject files?

2 10175

Can you copy the session to a different folder or repository?

2 11797

When the informatica server marks that a batch is failed?

1 6004

What is a command that used to run a batch?

2 7511

In a sequential batch can you run the session if previous session fails?

4 10894

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the issues you have faced in your project? How did you overcome those issues?

2365

Differentiate between sessions and batches?

1018

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1909

How can you increase the performance in joiner transformation?

1190

What will be the approach?

979

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2035

What are the popular informatica products?

1012

what is informatica metadata?

1037

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7449

what is SDLC way of code development?

2042

What is the use of target designer?

1054

What do you mean by enterprise data warehousing?

1065

Why union transformation is an active transformation?

1047

How to create the source and target database connections in server manager?

1090

How to open an older version of an object in the workspace?

1204

For More Un-Answered { Informatica } Questions Click Here