A data staging area (DSA) is a temporary storage area between the data sources and a data warehouse.
The staging area is mainly used to quickly extract data from its data sources, minimizing the impact of the sources.
After data has been loaded into the staging area, the staging area is used to combine data from multiple data sources, transformations, validations, data cleansing. Data is often transformed into a star schema prior to loading a data warehouse.
In TX the data staging area is implemented as a Staging Database owned by a Business Unit object. There is a 1:1 relationship between staging databases and business units. To have multiple staging areas you must have multiple business units. You have to have at least one business unit within a project, thus you will always have at least one staging area.
In TX you cannot load directly between data sources and a data warehouse.
This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-24.