What's different about a data warehouse is that all of the information from the line of business or source systems gets rearranged into two types of information:
Dimensions contains a group of descriptive attributes. An example is a product where we have its colour, size, description, product group, product category etc. It should have a single part primary key and then everything else is typically made up of flags and strings.
read more »
Be the first to post a Comment!