Load from DSO to Infocube in BI 7.0
I am loading data from DSO to cube. While doing a full load in the DTP maintenance, I selected 'Extraction from' as Active Table (Without Archive), it went fine. When loading Delta Init, I wondered what option needs to be selected for 'Delta Init Extraction From', whether Active Table or Change Log? What is the logic behind this? Can you please explain?
I know, after the delta Init, all the subsequent delta loads will be loaded from the change log table of the DSO automatically.
Kiran Vasant Kere replied
Hi Shiva Kanth,
When we check data which is available in DSO we go to active data table and not change log table.
Change log table create the records and stores the history based on the before and after image. Ultimately based on logic it posts records to active data table.
Hence when you will load data to cube it should be from active data table.Active data is summary and change log is like like item of the record.
I hope it is clear for you.
Thanks and regards