. After some further analysis, you discover that the Commission field in the Policies table is updated yearly to reflect changes in the annual commission paid to agents on existing policies. Would knowing this information change the way in which you extract and load data into the data mart from the OLTP system?

Problems and Exercises 9-55 through 9-62 deal with the Sales Analysis Module data mart available on the Teradata University Network

(www.teradatauniversitynetwork.com).To use the Teradata University Network, you will need to obtain the current TUN password from your instructor. Go to the Assignments section of the Teradata University Network or to this textbook’s Web site to find the document

“MDBM 13e SAM Assignment Instructions” in order to prepare to do the following Problems and Exercises. When requested, use course password MDBM13e to set up your SQL Assistant account.