I am currently sourcing data from 5 staging tables. Each of these tables store data which will be loaded in to the fact table and a number of dimension tables. The dimension data is common amongst all 5 staging tables.
I'd like to run a workflow which loads the dimension table data first and then the fact table load will run. That would ensure that none of the fact rows error out due to missing dimension data. Let's assume I have a dimension called business_unit. Is it wise for me to create 5 workflows, each that will read business unit from the staging area tables and load it?
Is there anyway I can just do all the above in one workflow within BODI? Are there any transforms which support that?