ORA-33003: (XSAGDIMDROP) workspace object, to be transformed
during data load, must be a base dimension and not otherwise
referenced in the AGGMAP.



ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimen..

Answer / guest

Cause: The user tried to specify a dimension in a
dataflow-related clause in an aggmap which is already in
another RELATION statement, DIMENSION statement, or possibly
dimensioning the AGGMAP, or they specified a composite or
conjoint dimension, or an object which is not a dimension

Action: Remove the conflicting reference or specify a valid
object

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-51200: open keymap failed for index id = string

1 Answers  


ORA-16732: Error executing dbms_logstdby.skip procedure

1 Answers  


ORA-16004: backup database requires recovery

1 Answers  


ORA-16563: unable to add value, syntax error at "string"

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  






ORA-29516: Aurora assertion failure: string

1 Answers  


RMAN-06511: RMAN retention policy is set to redundancy number

1 Answers  


ORA-32409: materialized view log on "string"."string" already excludes new values

1 Answers  


ORA-02273: this unique/primary key is referenced by some foreign keys

2 Answers   KIIT,


NNL-00343: Log file name is now string

1 Answers  


ORA-31113: XDB configuration may not be updated with non-schema compliant data

1 Answers  


ORA-24904: invalid callback attribute passed into OCI call

1 Answers  


Categories