Lookup (not intelligent lookup) and updating data in Datasphere

[amithrajkr-1]

Hi Experts,

I have requirement where i need to update the New/Delta records in my existing Dimension view by comparing with other dimension view.

For example

If A from view1 not equal to B from View 2

Then Update .

is there any way i can achive this using sap datasphere

[Simon_Ye]

Hi,

Technically yes, you can simply build a view on top of view 1 and view 2 you mentioned, and add a flag indicating if records from view 1 exist in view 2 or not; then build two flows to update the target table.

But to master data, we generally overwrite the target table, we don't care if the operation is UPDATE or INSERT unless you want to build a time-dependent dimension.

Regards,

Simon