3.2.5. Create Star Schema

Now let’s assemble the dimensions and facts jobs into the complete star schema:

  1. Add the START node to start the job.

  2. Start the job with the Check Db connections condition.

  3. In case the DB is not connected, add the Abort job node for the job.

  4. Then add consequently Update Dimensions and Update Facts jobs that we have designed earlier.

  5. Finalize the job with the Success node and run the job:

    star schema 14
    Figure 15. Star Schema job

  6. Save all the job and transformation files in the project folder for further use.