Problem with Transform Map

[atul3]

Hi All,

I am trying to load the data in ServiceNow using Data Source. Initially, I am trying to load top 20 records in my target table.

Data Source run successfully and it loaded the records in the Source Table (Extends Table: Import Set Row). But when I am executing my transform map, records are not reflecting in the target table. Mapping has been done. But don't why it is not working.

If i am trying to do this activity by excel file import. It worked fine. Please suggest me something how to resolve this problem.

Thanks in Advance!

Regards,

Atul Chauhan

[Deepak Ingale1]

Can you check the import log histroy?

That will give you an idea if any errors are there while importing data.

[santoshsahoonis]

Do what Deepak said and you should be able to see why.

Step 1: Goto sys_import_set.list

Step 2: Select the import set(something like this ISETxxxxxxx)

Step 3: Check 'Comment' or 'Error' in the related list 'Import Set Rows'

[atul3]

Thanks for response Deepak and Santosh.

Yes, I have checked the import log history. There are no errors. It shows state as "Processed",

Please see the snap shot below-

Thanks,

Atul Chauhan

[santoshsahoonis]

That shows that your Data Source is not fetching any records to be transformed. Verify if the Data source used has correct credentials/details