You might be wondering which distribution model you should use. The answer has to do with the table category to which the table you are creating belongs; see Table 2.3. TABLE 2.3 Table category distribution matrix Category Distribution model Staging ROUND_ROBIN Fact HASH Dimension (small table) REPLICATED Dimension (large table) HASH STAGING TABLE A staging […]
In its most common use, an index is the place you look for a key term to find a page number for the detailed explanation of that term. You will find an index at the end of this book. If you look for the term Index, you will find this page referencing it. An index […]
Two problems that have come up regarding relational databases over the years have to do with the complexity of SQL queries and the difficulty of representing objects. The simple structured database you created in the previous exercise contains six tables. Creating a query to join three, four, or even five of those tables together would […]
