Unable to generate Key in Dimension Tbale
962386Nov 28 2012 — edited Nov 30 2012Hi All,
I am trying to populate Dimension(DIM_PHASE) table's PHASE_KEY by interface by using IKM Oracle Incremental Update.
I am getting the error like:-- 936 : 42000 : java.sql.SQLException: ORA-00936: missing expression
When PHASE_KEY is not 1> Actively mapped...
2> No value is mapped with this column
3> This key is the update key
4> In DIM_PHASE model the table's OLAP type is Slowly Changing Diamention
5> In the Model the key PHASE_KEY is defined as Undefined/Surrogate key.(both the case geting error)
After Putting 1> Active Mapping for the column PHASE_KEY
2> value given is 1
3> enabled Insert ,Update and uncheck not null.
Then its failing is insert PK errors.. telling PK PHASE_KEY is not unique.
As flow control is yes and it is checking the columns in I$ table. But if I am not giving the active mapping then also its failing.
What to do in this scenario.
Please help.
PS.- Trigger is created in DB to insert into PHASE_KEY column with sequence.nextval at the time of inserting any value in DIM_PHASE table.
I am Using ODI 10g.