1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the need of building a data warehouse?

Question Posted / kishoreakkarapaka

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

how to obtain performance data for individual transformations.

2 Answers  

how many types of dimensions are available in informatica?

0 Answers  

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

What is a surrogate key?

0 Answers  

What is the Difference between sorter and aggregator?

2 Answers  




How do you use reject loader.

0 Answers  

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

what is casual dimension?

6 Answers   IBM,

without update strategy how to insert &update?

1 Answers   DELL,

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

For more Informatica Interview Questions Click Here
Categories