by Vels | Apr 17, 2013 | Desktop, Project Design Process
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...
by Vels | Apr 16, 2013 | Desktop, Project Design Process
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...
by Vels | Apr 15, 2013 | Desktop, Project Design Process
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...
by Vels | Apr 13, 2013 | Desktop, Project Design Process
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 ...
by Vels | Apr 13, 2013 | Desktop, Project Design Process
The first step in the project design process is to design the logical data model. Before getting to know how to design a logical data model, lets understand the basic concepts of logical data model & how it plays a role in MicroStrategy project (ie) the components...
