cancel
Showing results for 
Search instead for 
Did you mean: 

Lookup (not intelligent lookup) and updating data in Datasphere

amithrajkr-1
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Simon_Ye
Employee
Employee
0 Kudos

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