Changing the Object_type on a record within CUAND_CE_IA_PROD Hybris Marketing

[Former Member]

Hi,

So the scenario we have is that we have a load of interactions which have been loaded into our Hybris Marketing on-prem system (1611). These interactions also have products on them so it is also populating the table CUAND_CE_IA_PROD. However whilst building our ODATA service we didn't load the correct "OBJECT_TYPE" against the interaction. We later changed this to the correct object_type however the old data is influencing our Recommendation Model. We need to change this on the record so that our predictive models and scores actually start showing some meaning for a demo.

Is there a simple way of changing this by writing an SQL script in HANA for this table or are more table impacted.

[former_member226 · Accepted solution]

Hi,

You can write a HANA SQL query to update the Content. But while updating you have to make sure that table

CUAND_PROD_FACET field PRODUCT_ORIGIN is also updated.

Here CUAND_CE_IA_PROD-PRODUCT_KEY = CUAND_PROD_FACET-PARENT_KEY

Thanks

Saurabh