Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI 12c Getting Started Demo Appliance: Update Key Question.

Manoj DixitJan 31 2018 — edited Feb 6 2018

Hello,

I am going through the ODI 12c Getting Started Demo Appliance.

I tried to create a similar mapping (Map TRG_CITY) to load data into TRG_CITY table. However, I am not able to set the Update Key blank. But, the demo mapping "Load TRG_CITY", has the update key blank.

Below is the demo mapping "Load TRG_CITY" where the update key is blank.

Load TRG_CITY Update Key is Blank.PNG

Below is my mapping, where I am not able to set the update key blank.

Map TRG_CITY Update Key cannot be set Blank.PNG

I have noticed, also, that the demo "Load TRG_CITY" mapping, allows to uncheck the TRG_CITY's key attribute.

Load TRG_CITY CITY_ID Key can be Unchecked.PNG

However, in my mapping, I am not able to uncheck the CITY_ID key attribute as it's grayed-out.

Map TRG_CITY CITY_ID Key is Grayed Out.PNG

Could someone please let me know how to set the update key blank? I am using the out of the box TRG_CITY datastore/table. And also, why I may not be able to un-check the CITY_ID key attribute?

Thanks in advance.

Regards,

Manoj.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2018

Added on Jan 31 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

8 comments

919 views