Hi All,

How to split master data tables into Facts and dimensions for below scenario:

Three individual tables:

Work Order -  which have details of an work order.

Columns:  wo ID, status, desc, date, some measure

labor -  which have details of a labor assigned to the above wororder

Columns: wo ID, LaborID, location, date,  department , hours and some measure

Tools -  which have details of a tool used by a labor for the  above wororder

Columns: WO ID, toolsid,asset No, date, toolrate, tool hours and some measures.

Scenario:

a work order have multiple labor assigned and  multiple tools used.

Wo ID is the only column which is available in three tables.

So, could you please suggest , how can i split all these three tables into facts and dim's and maintain a star-schema model in Physical layer.

Note:

I am able to split tables into Facts and dimensions, but not able to model the data.

Any suggestion would be highly appreciated.

Regards,

Chandu.