Database Reference
In-Depth Information
■
To solve the issues of code conversion and reformatting, we recommend using the Query Designer to type
out the basic syntax for your sQL statements and then closing the tool and completing the statement by hand. Using
this combination will provide you with a quick and easy way to write sQL code.
Note
Figure 6-13.
Reformatting and updating your query code
Updating Your BI Documentation
This chapter has focused on developing SQL code for your ETL process. The general consensus seems to be that
most developers dislike creating documentation. And yet, documentation is an important aspect of completing
any solution, and that documentation must be upgraded as progress is made toward the completion of the
solution.
In this topic, we have tried to keep the documentation requirements to a minimum. So far, we have
simplified this process by using an Excel spreadsheet to document the solution objects. Because this is currently
our only form of documentation, we need to keep it up-to-date by recording our transformation logic in the
spreadsheet.
Figure
6-14
shows an example of adding the transformations required to the data warehouse objects
worksheet. Doing this provides two distinct advantages. First, it gives you the opportunity to let other developers
know what kind of transformations have occurred without having to read complex SQL statements. And second,
it provides you with a way of verifying that you have completed coding all the transformations in your list.
