what is the solution to duplicate records coming in stagging table in Intune integration with SNOW?

Sandeep _1 · ‎08-08-2023

AJ_TechTrek · ‎01-16-2024

you should check the IRE rules for particular class as well as check the coalesce filed for idenfication, using which record are update and created, also that can be issue with Unique ID which coming from Intune.

Please verify the same.

thanks

AJ

View solution in original post

Sohail Khilji · ‎08-08-2023

Hi,

Having duplicates on staging table is fine, but before transform Make sure you have set 1 or more than 1 primary key, i.e. to set the collace field value to True for one or more fields.

☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

pratiksha5 · ‎08-09-2023

How you are importing the data from stagging to CMDB? If using IH ETL then IRE will take care of the duplication issue. If you are using an import set then make sure you call IRE manually.

Sandeep _1 · ‎08-11-2023

hi,

I am using an import set

pratiksha5 · ‎08-11-2023

Stagging table if you want that it should not have duplicates then that needs to be fixed at the source. While loading the data in CMDB the data will not be duplicated if you use IRE. Try IH ETL it calls IRE before loading the data in CMDB.