Page tree
Skip to end of metadata
Go to start of metadata

Similar to a Data Warehouse and its multiple Star Schemas, the Job loading the entire system should have one Workflow for each Star Schema, we call it a Section. As a Section is a reusable Object per definition - Components so to say - we name those objects C_...._Section. And a Section for sure requires some other objects loaded upfront - all the dimension tables for this star schema at least - so a WorkFlow containing all the Dimensiontable Components is the first object. After that, in almost all cases, you will have a Conditional to distinct between Initial and Delta load of the Fact Tables.

The first workflow simply lists all Component Workflows to load the individual dimension tables in parallel.

  • No labels