Imported records are getting disappeared from the table

[Harish74]

Hi,

I have loaded some records through Data source using JDBC connection. More than 6000 records got inserted into my custom table. But when I checked the same table after few minutes, the table is empty with no records in it. I did checked for the deleted records. But there is no audit of deleted records from this table. Don't know why the records are getting disappeared.

Workaround I did was I opened the same import set and  loaded the records again. But again after few minutes same issue persists.

Can someone help me on this to make the records stay?

[Chalan B L]

Hello Harish,

Check in the transform script if there is any script to delete the records loaded in the staging table
Usually there will be onAfter transform map scripts where they would use some logic to clear the records

Please mark this answer as helpful or correct if it addressed your problem.

Regards,
Chalan

[Harish74]

Hi,

There is no transform scripts that I have created or running on this data source. I did checked the Import set logs and the last updated log it says number of records got inserted(6027).

[Logan Poynter]

This sounds like an issue with the transform map and the records not being saved into the table (just the staging table before the transform runs). Have you checked your import log already?

[Harish74]

Hi,

I did checked the Import set logs and the last updated log it says number of records got inserted(6027). There is no log of deleting records.