ETTL, one of the most challenging tasks in building a data warehouse, is the process of extracting, transforming, transferring, and loading data correctly and quickly.

A free characteristic is a characteristic in a query used for drill-downs. It is not displayed in the initial result of a query run.

The Full update option in the InfoPackage definition requests BW to load all data that meet the selection criteria specified via the Select data tab.

Generic data extraction is a function in Business Content that allows us to create DataSources based on database views or InfoSet queries. InfoSet is similar to a view but allows outer joins between tables.

Granularity describes the level of detail in a data warehouse. It is determined by business requirements and technology capabilities.