ORA-30367: a JOIN KEY clause is required



ORA-30367: a JOIN KEY clause is required..

Answer / guest

Cause: A JOIN KEY clause was omitted in a dimension
statement. A JOIN KEY clause is required when the child
level and the parent level are not in the same relation.

Action: Specify a JOIN KEY clause to indicate how the
relation of the child level joins to the relation of the
parent level.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11845: No Partial Update

1 Answers  


ORA-22808: REF dereferencing not allowed

1 Answers  


PCC-00027: Redeclared SQL Identifier "string" at line number in file string

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


PCC-02331: undefined SQL identifier

1 Answers  






NNL-00284: Scheduled cache checkpoint to occur in string

1 Answers  


ORA-02450: Invalid hash option - missing keyword IS

1 Answers  


ORA-00074: no process has been specified

1 Answers  


ORA-30381: REWRITE_TABLE is not compatible with Oracle version

1 Answers  


TNS-00532: No previous async operation to wait on

1 Answers  


ORA-13765: Value "string" is illegal for a result limit.

1 Answers  


ORA-28541: Error in HS init file on line number.

1 Answers   IES,


Categories