Best practices to design jobs and transformations

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.

Styling your work

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...