ORA-30336: no child for specified JOIN

admin

ORA-30336: no child for specified JOIN KEY
Cause: The level specifiedin the REFERENCES portion of a JOIN KEY clause in a
dimension DDL statement does not have a child level.
Action: Check the spelling ofthe level name referenced in the JOIN KEY clause. If
the referenced level is the first level in the hierarchy, you need not and mustnot
specify a JOIN KEY clause.