Follow

What is a Data Staging Area?

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.

Was this article helpful?
0 out of 0 found this helpful

2 Comments

  • 0
    Avatar
    Mark Chinsky

    There was an article or video explaining why TimeXtender now recommends a DSA in the Datawarehouse area, in addition to a staging database and putting all your etl in the DSA instead of in the staging area.  Older content on the site doesn't show this.  Now I can't find it to save my life.

    Do you have a link or video that explains why you want to keep your ETL out of the initial Staging area?  I believe it makes it alot easier to change your source.

    Edited by Mark Chinsky
  • 0
    Avatar
    Joseph Treadwell

    Hi Mark, 

     

    I think you may be referring to this video in the online training: http://learn.timextender.com/courses/240391/lectures/3782740

    Fast forward to 1:00. 

Please sign in to leave a comment.