Design Decision - BODI

[Former Member]

Hi,

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?

Thanks

Azeem

[Former Member]

Thanks for that.

[werner_daehn]

You just said it, you need to load the dimension tables first. Altough you can use some tricks to ensure that I would use the cleanest way, I would have 5 workflows/dataflows reading the same stage table multiple times like you suggested.