Best practices not only make the development process easier, but also improve the quality of your ETL processes and facilitate their maintenance. By considering the following list of best practices, your projects will have more chances of success.
The following is a simple list of practices to take into account while working with Spoon:
- Outline your ideas on paper before creating a Transformation or Job. Don't drop steps randomly on the canvas trying to get things to work; otherwise, you will end up with a Transformation or Job that is difficult to understand and might not be of any use.
- Document your work:
- Write at least a simple description of the Transformation and Job properties windows.
- Replace the default names of the steps and Job entries with meaningful ones.
- Use notes to clarify the purpose of transformations and jobs. Color-code your notes for a better effect; for example, use a color for notes explaining the purpose...