✍ Kashif M
Trends

Sunday, 7 July 2013


Enterprise Data Warehouse (EDW) & Data Mart?


By on July 07, 2013

EDW consists of all the information associated with the entire Organization. 

For example, it will contain information about all the departments (Say Finance, Human Resource, Marketing, Sales etc).


Where as Data Mart ONLY contains the data that is specific to one department (Say only Finance).

Kashif
mkashu: Enterprise Data Warehouse (EDW) & Data Mart?
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "Enterprise Data Warehouse (EDW) & Data Mart?"

2 comments:

  1. What is factless fact table?

    ReplyDelete
    Replies
    1. factless fact ia also a fact table,but is has'nt contain measure columns.
      mostly factless fact are used for count operations

      Delete

Blog Archive