Hi,
I am trying to understand how BW load data from ODS to cube. Is it reading active table or changelog table. It is not clear for me.
I have an ODS where I deleted all the changelog Data via RSA1,
modeling, PSA. I went into the ODS manage, I check the content of the
changelog table 0 records and I check the content of active data 728
records.
I run a full and also a INIT infopackage from the ODS to the cube and 728 records
was transfered and added to the cube, I was expected no records because
the changelog of the ODS is empty
Can you explain this please.
Do you think it reads each records from the active table of the ODS and
check if there is some changelog records (ODSR requests) , if no
records exist in te changelog it will load the active records only to
the cube ? if there is changelog records (ODSR requests), it will load
the changelog records to the cube ?
I saw also that if in the infopackage from ODS to the cube I load to
PSA also in the settings, the requests are created (REQU_ requests) in
the changelog table. Those records in the changelog table are they
process when we upload from ODS to cube ?
thank you