Full data load without PSA
We are having certain data sources which are not supporting delta. So we need to run full data load on daily basis. Sometime this full data loads are multiple time in a day.
Some Full Data loads are:
- Master data load
- Master data text load
- Full load to DSO
- Full load to Infocube after every full content and PSA deletion
This full type of data loads are keep increasing our data base size. As PSA will hold this data and we cannot override PSA. In other hand we are having one solution to delete this PSA after every successful data load to target. This consumes extra time as well as this is extra burden on Application server with database server. 🙁
BW 7.3 powered by HANA is come up with new feature where we can skip PSA data load. Our data is directly getting loaded throw DTP itself.
In DTP maintenance screen we can specify that to not extract data from PSA. So now we can directly load data from datasource without loading to PSA using InfoPakage.
The flag “Do not extract from PSA; use direct access to data source” will display if the DTP source is a DataSource from operational source system. PSA layer becomes optional now.
This option reduces load of BW housekeeping activity. 🙂
just a small note:-
i have seen this feature available for DTPs set to 'Extraction Mode' Full even before BW 7.3
@duncan : it was available in 3.x modeling .
and new feature came in sap hana @ dtp level.
Thanks for sharing your knowledge.
Thank you Sandeep
Thanks for the valuable info
To leverage this option, what SP should we need to have?
We're using BW 7.3 on hana with SP 09...
Or is this option is from BW 7.4 onwards?
The Full DTP with "Do not extract from PSA" option is not a HANA dependant feature and it available from 7.30 release.