What is a staging area? Do we need it? What is the purpose of a staging area?

Staging area is place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data , and perform data cleansing and merging , before loading the data into warehouse.

 

What are the modules in Power Mart?

  1. PowerMart Designer
    2. Server
    3. Server Manager
    4. Repository
    5. Repository Manager

 

What is Full load & Incremental or Refresh load?

Advertisements