Full load and Delta with a Staging table

[Former Member]

The steps before loading the records into the data warehouse are ...

1-Extract

2-Transfrom ( cleansing and combining joins)

3-Loading the data

During the firts load we do a full load in the target table .Of course the staging table receive this full load as well.

However the second time we process the records , we do a delta in the target table .

I was thinking ... does the standards recomend to load all the records again in the staging table or only the delta has to be loaded in the staging table .

Thanks

[Former Member]

Hi,

If your data source supports delta and your business requirement also gets satisfied with delta extraction then you can surely go for delta extraction.

But if your data source doesn't support delta extraction then you can always delete the existing contents in the staging data (PSA) for loading next data request. And then further you can manage delta in BW using DTP.

Regards,

Durgesh.

[nikhil_joy2]

Hi,

Refer below links for a better understanding.

[http://forums.sdn.sap.com/thread.jspa?threadID=1202535]

[http://help.sap.com/SAPHELP_NW04S/helpdata/en/80/1a65dce07211d2acb80000e829fbfe/content.htm]

Hope it helps you.

Regards,

Nikhil Joy