Retail Predictive Application Server (MOSC)

MOSC Banner

RDM Table Size Concern

edited Jun 2, 2017 1:24AM in Retail Predictive Application Server (MOSC) 3 commentsAnswered

Hi,

We have implemented integrated RPAS environment where MFP, LP and AP are integrated through HSA.

We have RDM Dim tables for PROD holding around 1,260,000 item~colors.

The partition dimension is at group level.

We are going to implement program planning in another few months where we will be introducing more item~colors, in worse case another 1 Million item~colors.

Our concern is the measure data might become too huge - RDM shared measures as well as the domain measures size. Also the domain size will increase.

Is there any limit to how much data RDM tables can hold for optimum performance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center