top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can i build a datawarehouse and better to explain me the logical structure of that?

+1 vote
How can i build a datawarehouse and better to explain me the logical structure of that?
posted May 20, 2014 by Akriti

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Steps to build Data-ware house:

  • Gathering business requirements.
  • Identifying Sources
  • Identifying Facts
  • Defining Dimensions
  • Define Attributes
  • Redefine Dimensions & Attributes
  • Organize Attribute Hierarchy & Define Relationship
  • Assign Unique Identifiers
  • Additional conventions:Cardinality/Adding ratios

Hierarchies are logical structures that use ordered levels as a means of organizing data. A hierarchy can be used to define data aggregation. For example, in a time dimension, a hierarchy might aggregate data from the month level to the quarter level to the year level. A hierarchy can also be used to define a navigational drill path and to establish a family structure.

Within a hierarchy, each level is logically connected to the levels above and below it. Data values at lower levels aggregate into the data values at higher levels. A dimension can be composed of more than one hierarchy. For example, in the product dimension, there might be two hierarchies–one for product categories and one for product suppliers.
Dimension hierarchies also group levels from general to granular. Query tools use hierarchies to enable you to drill down into your data to view different levels of granularity. This is one of the key benefits of a data warehouse.

When designing hierarchies, you must consider the relationships in business structures. For example, a divisional multilevel sales organization.

Hierarchies impose a family structure on dimension values. For a particular level value, a value at the next higher level is its parent, and values at the next lower level are its children. These familial relationships enable analysts to access data quickly.

answer May 21, 2014 by Anshika Utadi
Similar Questions
+2 votes

Is there any library or a plug-in to enable the temporal upward compatibility? I want to keep the past records whenever a current record changes.

+1 vote

Please let me know the different types of SCD with example.