Refacing Your Database, Part 3
May 3, 2016 Paul Tuohy
|
In the preceding two articles, we saw how to extract, analyze and correct table and column definitions. In this, the final article on refacing your database, we look at some more options for re-representing data and, finally, generating a script to create the required views. Handling Numeric Date Fields One of the issues we need to handle is the representation of dates in the SASALHST table. Figure 1 shows how the purchase date is stored as a numeric field, the order date is stored as a year, month and day and the delivery date is stored as a century, year, |
