Creating Tables

Once you have determined the data needs of the users of the data warehouse, based on the most vital business functions of the enterprise, you can begin to build a database using the basic principles of OLTP database construction. However, keep the following star-schema guidelines in mind: