Data Mart Loads
For data mart loads should we avoid loads into a PSA (assuming self system) or is there any reasons that this may be required? Thanks
Dinesh Kumar replied
Hi Niten,
Actually you dont need the PSA in datamarts as the data is already there in the source data target. In case of ODS -> Cube you dont have the option of PSA as the change log table of the ODS acts as the PSA for the cube.
Bye
Dinesh