Oracle Data Integrator 10.1.3.4.8_01
Is there any known issue with ODI version in the subject regarding convering nulls in the mapping of an interface? For instance, my mapping is as follows: ISNULL(TRANSACTIONS.defect_reason,'N/A'). But I still get records in the table will null in defect_reason. Also, I get duplication of records based on PLANT and HJID columns, even though these have a check in the "Key" box in the mapping area of the interace. I have a feeling this is somehow related to null values in columns. If you suggest an upgrade , we are working on going to 11g, but it will be a
0