In this chapter, we will go up to the job level and review the steps in the development process that make a successful and robust ETL solution. All recipes presented in this chapter can fall into one of the three categories: ETL development, ETL troubleshooting, and ETL reporting. These categories include design techniques and processes usually implemented and executed sequentially in order within the ETL life cycle.
Here, you can see which topics fall under which category.
Developing ETL:
Projects and jobs – organizing ETL
Using object replication
Migrating ETL code through the central repository
Migrating ETL code with export/import
The developing category discusses issues faced by ETL developers on a daily basis when they work on designing and implementing an ETL solution in Data Services.
Troubleshooting ETL:
Debugging job execution
Monitoring job execution
The troubleshooting category explains in detail the troubleshooting techniques that can be used in Data Services Designer to...