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 of a Transformation, and a different ...