Monday, 21 May 2012

ORA-30401: JOIN KEY columns must be non-null

ORA-30401: JOIN KEY columns must be non-null

Cause: The dimension statement failed because the column(s) in the JOIN KEY clause permitted NULL values. The JOIN KEY columns are related to the columns of the dimension s skip levels in one or both of the following ways: 1. A skip level is defined over one or more of the JOIN KEY columns. 2. The attribute clauses of a skip level determine one or more of the JOIN KEY columns.

Action: Modify the JOIN KEY columns so that they do not allow NULL values.

No comments:

Post a Comment