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