What is the need of building a data warehouse?

Answers were Sorted based on User's Feedback



What is the need of building a data warehouse?..

Answer / ashish goel

Data warehouse is generally designed for analyzing the
business operations but not to run the business operations.

Is This Answer Correct ?    7 Yes 0 No

What is the need of building a data warehouse?..

Answer / vas.chiky

Having separate OLAP DWH database for analysis, increases
the performance of reports.

even during backup or crash period of oltp, OLAP database
will not get affected.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,


How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,


what is the difference between static and dynamic

4 Answers   TCS, Wipro,


How can you access the remote source into your session?

1 Answers  






can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  


What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,


write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,


In which scenario did you used pushdown optimization?

1 Answers  


what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  


Why we require dwh in particular projects?

1 Answers   Amdocs,


Categories