What is staging table in BW?

[Former Member]

Hi Experts,

Can you tell me what is staging table in BW. What does "staging" means? What is the definiction?definition? Where can i get more information about staging table ?

Thanks very much for your input.

[Former Member · Accepted solution]

HI,

Staging Table is nothing but the PSA Table.Here data will be stored in same as source system format(Raw data).These are the Transparent tables Two dimentional.Staging means before processing the data we will bring the data and store it in the same source system format.By this we can avoid disturbing the OLTP Syatem,because daily transactions are taking place in the OLTP syatem.In BI 7.0 PSA is mandatory.If data volume is very small in that case we can avoid PSA.

Tarak

[Former Member · Accepted solution]

Hi Tarak,

The data in PSA will not sync with the latest OLTP data. Is is correct?

Who or which compoent will be reponsible for update the PSA?daily? weekly? or ...

Thanks.

Allen

[Former Member · Accepted solution]

Hi,

PSa are flat tables and the records once loaded will not be changed.

Each record just sit in the flat table of PSA and is independent of other records.

Everyday delta loads or full loads happen into BI system from the source system through the process chain loads and therefore will bring changes to the existing records and new records.

Thanks

Ajeet

[Former Member]

Hi,

You can see this link for PSA.

http://help.sap.com/saphelp_nw70/helpdata/EN/7d/724d3caa70ea6fe10000000a114084/content.htm

Thanks

Edited by: Ajeet Singh on Dec 2, 2008 7:47 AM

[Former Member]

Hi,

In SAP BW, Staging table is the PSA (Persistant staging area).

Staging table are tables with flat structure where we bring the data from source tables initially.

After the data is in staging area, we do processing (in transformation or Update rules) and then put it into the data target (DSO, Infocube or infoobject).

Thanks,

Kartik