Integration ETL duplicate records

[rad2]

Hello,

I have exported data through integration ETL, in which i have two duplicate records(A and B). the difference is only in the RAM.

I have added a dynamic reconciliation rule to select the record with largest RAM. 

The IRE does not update the server with the higher RAM. it always updates the record that comes first.

Any idea on where the issue is?

I also do not get an de duplication task

Thankyou

[G Ponsekar]

Hi @rad2 ,

In your case, The IRE is likely finding only one CI that matches based on your current identification rules (e.g., just the Name or Serial Number), updating that single record and never triggering the deduplication process or the dynamic reconciliation rule for finding the largest value among multiple existing records. 

Please Review and refine the Identification rules for the cmdb_ci_server class. Ensure that the unique identifiers are correctly and completely captured in your incoming data. For example, if you have both Name and Serial Number for your servers, ensure that both attributes are configured in your identification rule.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[elsie78ash]

The issue likely lies with the reconciliation rule not being applied correctly or not being the primary selection criterion. The IRE is probably using a default rule, such as creation date or a different identification rule, to select the first record it processes. Ensure your dynamic reconciliation rule is properly configured and prioritized above other selection rules.