Records not available in Target table

Kavyasri
Tera Contributor

Hello community,

                       I am loading data from excel sheet to respective target table(cmdb_ci_ni_interface). After loading when I check the transform history I found 1,95,491 were inserted. But When I open the cmdb_ci_ni_interface table, I could not find any new records insertion. Screenshot (132).pngScreenshot (133).pngScreenshot (134).png

5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Kavyasri 

 

Do you access for this table (target table)? Any ACL or an filter condition blocking it?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hello @Dr Atul G- LNG ,

                                 If that is the case then the 20 records which are available in the target table were also loaded by me.

Hope you run the transform map after import set done.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Yes @Dr Atul G- LNG , Ran Transform map after import set