The CreatorCon Call for Content is officially open! Get started here.

Facing Issue on Hardware table model update using ETL

SabyasachiI
Tera Contributor

4 weeks ago

Hi, 

I have tried ETL on Hardware table where our primary goal is to update the Model ID of the records. Our data is created from instance by taking SYSID, Name, Serial Number, Serial Number Type, MAC Address , Product Model ID and in the ETL mapping we have mapped SysID as Native Key and rest to respective fields. So when we try to Run the ETL it update Hardware Records but left few records unchanged in it. Also if the Data is from Child Table even those records Model ID did not get Updated but we have a Reconciliation rule on Hardware table with high priority i.e. 30 ideally it should allow all the child tables of hardware too  

Any Suggestion, if we are missing anything?

SabyasachiI_0-1757581885426.png

 

SabyasachiI_1-1757581903546.png

SabyasachiI_2-1757581914556.png

 

 

 

 




 

0 Helpfuls
  • 158 Views
1 REPLY 1

Damhoej
Giga Guru

4 weeks ago

Have you tried to cleanse hardware model and then a split transform.
You will need the Model ID SYS_ID to populate the model ID attribute.
The cleanse operation look after an existing model ID and if not found create the model and returning the sys_id.

 

0 Helpfuls