Before you get to start knowing about the schema objects ( Attributes ) creation - you need to know about the relationships that exist in the database & then how to map them while you create attributes etc..One - One RelationshipFor attributes that have a...

Every table has a primary key that consists of a unique value that identifies each distinct record (or row) in the table. There are two types of primary keys:                    - Simple Key       ...

A physical schema includes the following two primary components:       - Columns       - TablesA physical schema consists of a set of tables, and those tables contain columns that store the actual data. The following topics...

The second step in the project design process is to design the data warehouse schema. Before you learn how to design a data warehouse schema, you need to understand the basic concept of a physical schema, how you use it in MicroStrategy Architect, and its various...

In the previous discussion we were seeing about the Logical Data model design principles & its components involved. Today lets have a better picture on the Attribute relationships which was also part of Logical Data modelling.Attribute relationships are essential...

As discussed earlier, the schema objects acts as the components for the logical data model. A logical data model includes the following three schema objects :                      - Facts     ...