Regarding Data model

[#1]

Hi  All

I have following Data model

able

Here i have two fact tabels One is orders and other one is orderDetails

so can u pls advise me to make them single table ..what i have to do??

i did concatination of both tables but pbm is

when i m trying see quantityOrderd per customer number data is not cmg(with out concat data is cmg crctly)

can anyone pls help me

[jagan]

Hi Narendra,

You should not concat this two tables, you can maintain it separately or you can join the tables based on the OrderNumber.

Orders:

LOAD

*

FROM OrdersDataSource;

Left Join(Orders)

LOAD

*

FROM OrderDetailsDataSource;

Regards,

Jagan.

[#3]

Hi Jagan

Orders table is Having 1400 rows

& OrderDetails is having 2996 rows

so if i do left join data will get duplicate ryt?? that time if i do any sum(quantityOrderd) will it give crct ans??

i attached My QVW file also

[jagan]

Hi,

You have QuantityOrdered field in OrderDetails table, so there should not be any issue.  Also make that OrderNumber is unique in Orders table, if not then don't join this tables otherwise you will get duplicate rows.

My suggestion is not to join.  In your attachment check there are lot of OrderNumber s missing for many rows almost 25% of rows do not have OrderNumber.

Regards,

jagan.

[#5]

Check below links:

May help you.

Fact Table with Mixed Granularity

Data Model best Pratice

Data model issue - Merging 2 fact tables into 1