Transform Maps - unable to insert data into table

Paul125
Kilo Guru

Hello - I am importing data from a SQL server so I created a Data Source and everything working fine until pulling the data into import set table. When I test load 20 records I can see the data in the import table. but I just mapped a string field but transform maps unable to create a single record. I make sure this record doesn't exist in table. Also, Coalesce is false. I don't know if I am missing something here but I can't even insert a single record.

1 ACCEPTED SOLUTION
9 REPLIES 9

SanjivMeher
Mega Patron

Did you also run the transform after loading the test records?

TR5
Tera Contributor

hey @SanjivMeher I have a follow-up question with the same scenario... I didn't see any error in the import log after running transform I can see fields created an alert on form but in the target table there are no records inserted, also I have tried running transform map by unchecking the business rule checkbox .
target table is awa_queue 

In the import table, is target table and target record set to a value? Can you check, if it got mapped to the right record? 

Paul125
Kilo Guru

Thanks for the reply Sanjiv. I did run the transform map, I also checked the transform history but it didn't have any inserts.