Help and Support > Table of Contents > Star Schema

Star Schema Block


About:

The star schema block creates a star schema by joining dimensions and a fact table. Dimensions are connected to the top reference stubs and providing columns to be joined are named identically all the dimensional information is connected to the fact table.

Star Schema Block Image

Block Connection Stubs

Inputs
Outputs
  • 1 The fact table data in.
  • 4 The joined result data out- with columns as selected in the block.
  • 2,3 The reference information coming in to be joined to the fact table.