Hi everyone,
I'm new to ODI and I was learning how to implement a sequence in a table.
I had already created my sequence in the database with the name DT.SEQ_SKEY. For my table, I set its OLAP type as Slowly Changing Dimension. In the table's attributes, I set one of its column as the surrogate key and fill in the column's expression as :DT.SEQ_SKEY.NEXTVAL.
However, when I clicked Validate, it said: “Cannot find mapping model object with name DT.SEQ_TEST_SKEY.NEXTVAL”. Furthermore, when I opened the Edit epression window and dragged the sequence from the list of sequences into the edit box, it showed the value :null.
Can someone tell me why this happened and how will I be able to fix it?