Source System
A database, application, file, or other storage
facility from which the data in a data warehouse is derived.
The definition of the relationship and data flow between
source and target objects.
Data that describes data and other structures, such as
objects, business rules, and processes. For example, the schema design of
a data warehouse is typically stored in a repository as meta data, which
is used to generate scripts used to build and populate the data warehouse. A
repository contains meta data.
A place where data is processed before entering the
warehouse.
The process of resolving inconsistencies and fixing the
anomalies in source data, typically as part of the ETL process.
It is the process of manipulating data. Any manipulation
beyond copying is a transformation. Examples include cleansing, aggregating,
and integrating data from multiple sources.
The process of moving copied or transformed data from a
source to a data warehouse.
A database, application, file, or other storage facility to
which the “transformed source data” is loaded in a data warehouse.
No comments:
Post a Comment