>Model 1

>Model 2

"Resant" <resant_v@yahoo.com> wrote in message
news:1120529234.304385.315440@z14g2000cwz.googlegroups.com...
>I work in consumer goods company and now design OLAP Data Warehouse.
> My OLAP tables consist of :
> 1. Customer - all our customer data
> {CustomerID, CustomerCode}
> 2. Type - type of the goods
> {TypeID, TypeCode}
> 3. Grade - quality grade of material
> {GradeID, CustomerCode, TypeCode, Grade}
> 4. Receiving - material receiving
> {ReceivingID, TruckNo, Transporter,...}
>
> I've design 2 kind of Receiving_Fact and don't know which one is better
> :
>>Model 1
> - Receiving_Fact
> {ReceivingID, GradeID, Measures}
> - Star Schema
> CustomerDim & TypeDim dimension will be related to GradeDim dmension
>
>>Model 2
> - Receiving_Fact
> {ReceivingID, CustomerID, TypeID, GradeID, Measures}
> - Star Schema
> CustomerDim & TypeDim dimension will be related to GradeID field in
>
> Receiving_Fact
>
> I hope my illustration could be understand well. Model 1 is like
> snowflake where dimension related to other dimension. Model 2 is star
> schma form which all dimensions related to fact table.
>
> Please help me, which model is better? I'm really confused.
>
> Thanks a lot
>