Tuesday, 30 September 2014

What is staging Area and Work Area?

What is staging Area and Work Area?


Staging Area : -
         - Holding Tables on DW Server.
         - Loaded from Extract Process 
         - Input for Integration/Transformation
         - May function as Work Areas
         - Output to a work area or Fact Table
         Work Area: -
       - Temporary Tables
          - Memory

No comments:

Post a Comment