
125
As a rule, the metadata found in the ETL environment is about data move-
ment and transformations (naturally!). Most of the metadata found in the ETL
environment is of the technical variety. However, ETL contains metadata that
has all sorts of business ramifications, such as:
Where the data came from
What changes or transformations were made to the data, if any, in transit
What summaries or other aggregations were created
When the last load occurred and whether or not it was successful
This information is extremely important to many businesspeople, especially
compliance and process analysts.
The raw content and format of mappings in ETL tools is ...