Do’s and Don’ts When Building Data Marts
In this chapter we will look at what should be done and what should be avoided when building data marts. The approach of this chapter is not to teach but to share experiences from practice.
The do’s and don’ts as they are called in this chapter are divided into three sections:
• process do’s and don’ts
• data mart handling do’s and don’ts
• coding do’s and don’ts
24.2 Process Do’s and Don’ts
24.2.1 Use Check Sums, Cross-Checks, or Peer Review
When writing a program that prepares an analysis data mart, the programmer or analyst is often seduced into ...