Let’s say we currently have some tables:
TableA
TableB
TableC
TableD
TableA and TableB are parents of TableC, then TableC is parent of TableD.
So we have:
Relationship | Parent Table | Child Table |
Rel1 | TableA | TableC |
Rel2 | TableB | TableC |
Rel3 | TableC | TableD |
We are trying to get rid of Table C, so that the new relationships will be:
Relationship | Parent Table | Child Table |
Rel4 | TableA | TableD |
Rel5 | TableB | TableD |
I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.
Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow?