What do u understand by Datawarehouse? How is it being used
by different organisations?

Answer Posted / pratik patel

Answer is absolutely correct but function answer.

Technical answer is:

A datawarehouse is one where consolidated data of the whole
organization (or a specific business area ) is stored in
such a way that efficient queries can be built on that for
analysis purpose.

A data warehouse should have following:
1. Facalitate ETL
2. Objects to store data for long period
3. Facilitate reporting on stored data

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What exactly do you know about the sap bw?

505


How we do the sd and mm configuration for bw?

538


Where do we use infoset in bi system?

492


what is virtual kef figures? what are the uses and in which case supposed to be use?

1400


What is the data target administration task?

532






What are the flags for general reporting?

1496


What are the differences between v1, v2, v3 jobs in extraction.

591


Explain the display properties?

1711


What is ud connect in sap bw system? How does it allow reporting in bi system?

508


How do you do EURO conversion at the database level?

1588


What are the general services supported?

1442


What are the data sources supported?

1703


when u creating infoobject it shows reference and template what is it

1811


How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --

4516


In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?

1603