How do you set a DATE column in a TARGET table to only be populated when a row is inserted?
I am building a fairly straight forward ETL project to migrate data from one Oracle DB to another Oracle DB using ODI 12.2.1.2.6.
On TARGET tables, four new columns are added to identify the source, batch process, create date and update date for each row of data.
All four of the new columns use project variables for their values. The problem is with the create date field called CREATED_DTTM (DATE).
For this field, in the 'Logical' editor and selecting the CREATED_DTTM field on my TARGET tables, I selected the 'Insert' button, but not the 'Update'
button. My intention is the CREATED_DTTM field would be populated when the record is inserted, and never updated.
I am using Oracle Incremental Update IKM to insert/update the data in the TARGET tables.
But when the mappings using this logic are run, all TARGET tables have NULL values in the CREATED_DTTM column for all records inserted by ODI.
The only way I can get the DATE values I'm expecting is if I select BOTH the 'Insert' and 'Update' buttons, which defeats the reason I have the two fields,
as both will always identical values.
Has anyone else run into this behavior? And if so, have you found a solution?