When you create or customize an extract, transform, and
load (ETL) catalog, you define the specifications for builds, reference
structures, connections, and other IBM® Cognos® Data Manager components.
Creating a fact build
To deliver fact data to your data warehouse, you need to
create a fact build. You can also use fact builds to deliver dimension
data. A fact build has a data stream, a transformation model, and
a delivery module.
Creating a dimension build
To describe a specific dimension of your business, you
need to create dimension builds to deliver dimension data into the
data warehouse. A dimension build has a source dimension table, a
hierarchy for the data, a target database, and a target table.
Creating a reference dimension
To hold the reference structures and templates relating
to a specific business dimension, you need to create a reference dimension.
The reference dimensions form the dimensional framework, which is
used for providing information when merging data and delivering dimension
data into data marts.
Customizing ETL jobs
The components that you can include in a job stream are
fact builds, dimension builds, SQL statements, conditions, procedures,
alerts, e-mails, or another job stream. Each component of the job
stream is a node that you can handle separately. You can define the
order of execution of these nodes and can execute a job stream sequentially
or in parallel.