Fact Table Options
Fact tables are huge. They are so huge that it should come as no surprise that much of your success will depend on how you implement your facts. Thus, I'm offering as general DBA advice my best Joe Friday from Dragnet imitation: “Just the facts …,” meaning if you get just the facts done right, you're well on the road to success.
But to do this right, you must look beyond just size. At any given time, fact tables will fall into one of three states:
Being queried (covered in Chapter 5)
Being loaded (covered in Chapters 6 and 7)
Being managed (covered in Chapter 8)
The key point is that to be successful, fact table implementations must accommodate the different requirements of all three states. Far too often, DBAs concentrate on ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
