Tutorials and Documentation > Table of Contents > Join

Join Block


About:

The join 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. Multiple data marts can be created sharing common (conformed) dimensions by chaining together join blocks using the triangular model stubs.

Join Block Image

Block Connection Stubs
Inputs
Outputs
  • 1 The fact table data in.
  • 5 The joined result data out- with columns as selected in the block.
  • 2 A base model to be available in the join- this allows the same references to be shared between join blocks.
  • 6 A combined reference set of all input references- to allow multiple join blocks to easily share the same reference.
  • 3,4 The reference information coming in to be joined to the fact table.