Data Loading is the process of placing the transformed data into the ElastiCube and BI-Studio/Web application.
In this stage, we will configure the build behavior of the source tables. This post will explain when to use each of the types:
With detailed transnational fact tables (for example: store quantitative information for analysis).
Keep in mind, that If an accumulate by column is not selected all data from the table will be added to the existing table.
With dimension tables (for example: stores attributes, or dimensions, that describe the objects in a fact table).
Ignore When Unchanged
With summary/snapshot fact tables and with data marts (smaller subsets of data, tailored for specific needs).