Populating ODS from Oracle table

[Former Member]

I am trying to load data into an BW ODS from an oracle table. The oracle table is partioned daily and is there a way of loading the data from one partion only.

What I am trying to accomplish it to bring one day delta data only.

[GFV · Accepted solution]

Did you consider DB Connect functionality? This way you can load data from DB Tables. BW in use should be 3.x: with lower relases there is a similar functionality (DB Link) based on a custom development.

For more detailed info see http://service.sap.com/bw under InfoIndex Area.

Hope it helps

GFV

[Former Member]

Please try loading the data using the Date in Selections of Scheduler - InfoPackage?