Transform map doesnt work

[samadam]

I have an import set table where I get data from data source. I have another table to load the data from that table. transform map is mapped to all fields in the table one to one. When I try to run the transform it just completes without errors and no inserts or updates. Not sure what is going on. Cannot get this to work. Any ideas? I don't see anything in the logs.

[VaranAwesomenow]

Does your transform map has an coalesce on it ?

You can see errors in syslog if there are any scripts running on target table that is preventing the transformation.

Are business rules enabled on your transform map ?

[OlaN · Accepted solution]

Hi,

Did you perform a "test load 20 records" in the data source when trying the transform?

If so, then the records will not actually be transformed by the transform map, it only runs and checks for errors.

You can either set the import set to "reprocess" to actually run and import the records via the transform map.

Or you can try to load all the data from the data source.

Another detail, if nothing has changed between the source records and the target records, nothing will happen, the transform will run, but all records will be skipped because nothing has changed.

[samadam]

Yes, that is the issue. I loaded all the data and it processed successfully. Thank you so much.