Question: Because data warehouses and even data marts can become very large, it may be sufficient to work with a subset of data for some analyses.

Because data warehouses and even data marts can become very large, it may be sufficient to work with a subset of data for some analyses. Create a sample of orders from 2004 using the SAMPLE SQL command (which is standard SQL); put a randomized allocation of 10 percent of the rows into the sample. Include in the sample results the order ID, product ID, sales rep region ID, month description, and order amount. Show the results, in sequence, by month. Run the query two times to check that the sample is actually random. Put your SQL query and a portion of the two answer sets (enough to show that they are different) into a file for your instructor.

Step by Step Solution

3.57 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

For this question youll need to refer to the Data Manipulation Statements SQL Assistant manual and the dbsamwh metadata manual from MicroStrategy that ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1958).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!