Skip to Content
0
Former Member
Apr 12, 2010 at 09:06 PM

partition ods

72 Views

Hi,

We have 4 ODS (one for month), and then a multiprovider to join them. The records of each ods are around 200.000.000, we are thinking about partitioning the active table. When the month changes, we want to delete one ODS (month - 3), and then we are going to load the new month in this ODS.

How can we partition the ods from BW?

The partitions must be recreated when the new month comes, this can be automatic?

Thanks

Victoria