So far, you have been working alone in front of your own computer. In the "Time for action" exercises, the step-by-step instructions along with the error-free sample data helped you create and run transformations free of errors. During the "Have a go hero" exercises, you likely encountered numerous errors, but tips and troubleshooting notes were there to help you get rid of them.
This is quite different from real scenarios, mainly for two reasons:
Real data has errors—a fact that can't be avoided. If you fail to heed it, the transformations that run with your sample data will probably crash when running with real data.
In most cases, who runs your final work is decided by an automated process and is not user defined. Therefore, if a transformation crashes, there will be nobody to fix the problem.
In this chapter you will learn about the options that PDI offers to treat errors and validate data so that your transformations are well prepared to...