ETL Infrastructure
- Staging Tier: The staging tier of the ETL transports data from a
source (the Cúram operational database) to a staging area.
- Central Data Warehouse Tier: Once the staging area is populated
with data, executing the Central ETLs pull data into the Central Data
Warehouse. Business logic is applied and data is manipulated, as
appropriate.
- Datamart Tier: This is the final stage of the Business
Intelligence and Analytics repository. Data is transformed into
dimensional format, and de-normalized to supporting ease of use, and
to ensure cube builders and report builders find the data easier to
model.