since I'm busy in my project. I'm sorry for late reply.
I assume that your concern is how to combine snawflake table to one dimention table in BMM layer. please correct me if I'm wrong.
there have two point:
1. don't change physical table
2. In BMM layer, you can build star mode first, for example:
physical layer: dimtable2----->dimtable1------->facttable1
you can build dimtable1-------->facttable1 in BMM layer, then, you drop and down dimtable2 to dimtable1's source in BMM layer. please make sure the column mapping is right.
this is simple sample, I know there have complex relationship in actual project, but I hope it can help you to think out solution.
good luck
[ 本帖最后由 KingComeHere 于 2009-3-9 01:39 编辑 ]
|