ORA-30337: multiple JOIN KEY clauses specified for the same parent level
What triggered the Error:
Multiple JOIN KEY clauses were specified for a given parent level in a dimension hierarchy.What should we do to fix it:
Match up each JOIN KEY clause with the level it references in the hierarchy. Eliminate the redundant JOIN KEY clause.