2020-04-18T11:55:00Z

Is a data warehouse the best option to consolidate data into one location?

BT
  • 9
  • 216
PeerSpot user
10

10 Answers

Victoria Mostova - PeerSpot reviewer
Real User
Top 5
2023-06-16T13:40:40Z
Jun 16, 2023
Search for a product comparison in Data Warehouse
DR
Real User
2021-08-05T13:39:59Z
Aug 5, 2021
RW
User
2021-08-05T18:01:16Z
Aug 5, 2021
DR
Real User
2020-04-23T14:58:38Z
Apr 23, 2020
BL
Real User
2021-08-05T19:12:54Z
Aug 5, 2021
BL
Real User
Aug 10, 2021

@Jay Allen 
Jay, Look again at sources for your own understanding. My understanding of top down data warehouse for an enterprise has an origin that has been trusted for decades. "Subject-oriented, non-volatile, integrated..." (crediting Bill Inmon). As a practitioner, I do admit that in my years a data administrator, I have encouraged a bottom up approach which imports recently historical data from operational sources into data mart(s) designed to be fact based with descriptive dimensions ... (credit to Ralph Kimball).  
With regard to B2B, partners in data exchange can link to either to operational database sources which are dynamic, or to data stores into which no-longer-volatile source data have been imported. -- Barbara

PeerSpot user
JA
User
2021-08-05T17:08:54Z
Aug 5, 2021
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: July 2024.
791,948 professionals have used our research since 2012.
CA
Real User
2021-08-05T17:03:37Z
Aug 5, 2021
SD
Real User
2021-08-04T10:16:49Z
Aug 4, 2021
RR
Real User
2020-04-22T22:31:20Z
Apr 22, 2020
OA
Real User
2021-08-04T13:51:19Z
Aug 4, 2021
Data Warehouse
What is a data warehouse? A data warehouse, sometimes categorized as an Enterprise Data Warehouse, (DW or DWH) is a data analysis and reporting system. Data warehouses are fundamental storehouses of integrated data from single, or multiple sources, storing historical or current data in one location where data is utilized, creating reports for designated Enterprise users. A DW is considered an integral component of business intelligence and describes a system used to analyze an...
Download Data Warehouse ReportRead more

Data Warehouse experts

AANKITGUPTAA - PeerSpot reviewer
Erick  Karanja - PeerSpot reviewer
Hamid M. Hamid - PeerSpot reviewer
Derrick Brockel - PeerSpot reviewer
Miodrag Milojevic - PeerSpot reviewer
Joyee Sen - PeerSpot reviewer
MartinPotgieter - PeerSpot reviewer
Sushrit Moundekar - PeerSpot reviewer