[email protected]

The delivery process begins with the cleaned and conformed data resulting from the subsystems just described. For many dimensions, the delivery plan is simple. Perform basic transformations to the data to build dimension rows for loading into the target presentation table. This typically includes surrogate key assignment, splitting or combining columns to present the appropriate data values, and joining underlying third normal form table structures into denormalized flat dimensions. Dimension tables are usually small, and subject to many transformations.