✍ Kashif M
Trends

Tuesday, 7 March 2017


What is Enterprisewide Data Warehouse ?


By on March 07, 2017


  1. Large scale implementation  
  2. Scopes the entire business  
  3. Data from all subject areas  
  4. Developed incrementally  
  5. Single source of enterprise wide data  
  6. Synchronized enterprise wide data  
  7. Single distribution point to dependent data marts

User Expectations

What is Enterprise wide Data Warehouse ?

Data Warehouse Vocabulary



Grain of Data - Granularity

Grain is defined as the level of detail of data captured in the data warehouse. More the detail, higher the granularity and vice-versa

•Fact table

It is similar to the transaction table in an OLTP system. It stores the facts or measures of the business.

Eg: SALES, ORDERS

•Dimension table

It is similar to the master table in an OLTP system. It stores the textual descriptors of the business.

Eg: CUSTOMER, PRODUCT

Kashif
mkashu: What is Enterprisewide Data Warehouse ?
Review : Kashif | Kashif
Update: March 07, 2017 | Rating: 4.5

Comment for "What is Enterprisewide Data Warehouse ?"

0 comments

Post a Comment

Blog Archive