Problems and Exercises 19 through 26 deal with the Sales Analysis Module data mart available on Teradata University Network (www.teradatauniversitynetwork.com). To use Teradata University Network, you will need to obtain the current TUN password from your instructor. Go to the Assignments section of Teradata University Network or to this textbook’s Website to find the document “MDBM 10e SAM Assignment Instructions” in order to prepare to do the following Problems and Exercises. When requested, use course password MDBM10e to set up your SQL Assistant account.
Review the metadata file for the db_samwh database and the definitions of the database tables. (You can use SHOW TABLE commands to display the DDL for tables.) Explain what dimension data, if any, are maintained to support slowly changing dimensions. If there are slowly changing dimension data, are they maintained as described in this chapter?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.