O'Reilly logo

Aster Data Database Administration by Todd Wilson, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 – Fact and Dimension Tables

“I saw the angel in the marble and carved until I set him free.”

- Michelangelo

Aster Tables are defined as Fact or Dimension when Created

image

An Aster Table will be either a Fact or Dimension Table. Fact tables are usually large, and dimension tables are relatively smaller. Fact tables will generally be distributed by hash on a distribution key, which is a key column in the table. Dimension tables are usually distributed by replicating the table across all vworkers.

Fact Table

image

A Distribution Key will be hashed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required