By definition, a data mart is a subset of a data warehouse designed for a specific group of users or a particular subject area.
Designing the data warehouse and data mart.
In this model, the business data warehouse is the collection of data repository databases (module), and the data marts are the databases from the data mart tier.
The data mart tier contains all the data marts, which are subsets of the data repository module, made simple enough for specific groups of end users to use in their data analysis activities.
This means that end users in one department can access and use the data in a data mart in another department.
Verify that the data mart design does not violate any business security Settings.
End users can only access the data mart granted to them, not all data warehouse data.
This is because it is not always feasible to consolidate enterprise data into a data mart or warehouse.
You take your food and plop in front of the television to find the same stupid smiley rolling down the isles of a Wal-mart AD, bringing customers shopping cheer as they peruse the super store.
Since data warehouse and data mart are interchangeable concepts in many situations, it is necessary to specify their definition based on the two-tiered warehouse model.
國文精選館
