Data Transformation Troubleshooting Tips

I am wondering what the rest of AETL users do to help troubleshoot a complex data transformation mapping.
What can I do when the output doesn't match what I think it should be?

I follow the logic from front to back again and again, but the results just don't match what I expect.

Could you please share any trouble shooting tips you might have?

John

Hi,

through extensive past experience, the best thing that you can do is to SIMPLIFY your mapping as much as possible to narrow down the problem areas

Joseph

Totally agree with Joseph.

Also

Start from the left and move to the right.
Spit complex transformations into several simple ones
Use data preview all the time
Enter and test your own data

Peter