Here is my example.

This is an 11g OBIEE environment.

The CRAFT table is being populated from a source system into a table that includes an "identity" column that is populated via insert trigger. When I manually add a record into the CRAFT table, the "identity" column populates with the CRAFT_KEY field. Here you can see that when I manually added LABORER to the table, the key field populated with a (6) value.

When I try to map data in using ODI, there is no source field for this column. This is a "new" column that will uniquely identify the record in the target database. So, how do I get the CRAFT_KEY to populate?

If I do a manual entry or do an INSERT INTO command, I simply leave the CRAFT_KEY out of the equation and then as each row is inserted, the trigger populates it.

For example:

INSERT INTO MXI_CRAFT (CRAFT, CRAFTID...SOURCESYSID) VALUES (CRAFT, CRAFTID...SOURCESYSID)

The absence of the CRAFT_KEY field in this type of query would allow the trigger to do its job.

How do I do the equivalent in ODI? How do I get the CRAFT_KEY to populate?

Thanks.