Transform Map Isn't Transforming

[johnfeist]

I have a very simple data source that is populated via JDBC from one of my SQL Server databases.  The data are two elements, employee number and cost center.  I've built a transform map to load the updates into sys_user.  Here's what that map looks like

When I run the transform, noting seems to be happening.  It shows successful completion but the logs show no inserts, changes, errors, skips etc.

I wrote a little script, separate from the transform map, that just grabs the data from the import set and iterates through looking for matching employee numbers.  That script shows that if finds all twenty employee numbers with some cost centers matching source = target and some not.  After the map "runs" thee are no changes.

I know this must be something simple that I'm missing so if anyone can tell me what that is I'll be most grateful to get this done.

:{)

[Allen Andreas · Accepted solution]

Hi,

I noticed that your result keeps being 20, are you doing the "test load 20 records" functionality as part of this? You didn't mention that and that's important as the result will always be 0 as the test load doesn't actually transform them and insert them.

So please do without the test load.

Alternatively, you can click "reprocess" on the import set and that would work as well, I believe.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[johnfeist]

Thank you Allen.  Once I hit reprocess everything worked as expected,

:{)