Dimension and Fact contain same fields

[Anonymous]

Hello everyone,

i need your help, i have 4 dim table product,prodcategory,prodsubcategory and salesterritory and 1 fact table internetsales

from them product dimension and internetsales fact contain a same field.

while i loaded this table in script & check data model it forms:

•        autoconcatenate in between product and internetsale
•        product and salesterritory have relationship between them
•        productcategory and productsubcategory have relationship between them (only connected to each other not to others)

so i used concatenate in between product and productcategory table and used QUALIFY and UNQUALIFY to internatesales table

after that  it create a snow flake schema model as ↓

i come to know , i am going with right way or there is another way to solve it, please let me know..

Thank you.

[Anil_Babu_Samineni]

Some what we are walking good approach. Here, I don't use QUALIFY Statement unless needed..

[Anonymous]

then what should i have to used beacuse it contain synthetic key

[Anil_Babu_Samineni]

In your model, I haven't seen any Synthetic Key. Any way, May be create Link Table to achieve this?

[Anonymous]

without using any function i load a script then it look like ↓

product(dim) and internetsales(fact) get autoconcatenate.

[Anonymous]

to create link table it required more than one fact table but in my model only one fact table is there.

[Anil_Babu_Samineni]

True, That is the case why are you using QUALIFY statement in your mode... I can't help now. It's late night to me. Going to sleep

[Anonymous]

ok,btw thank you so much..

[qliksus]

There is orderdate in both the  product and internetsale table So its better to create a common calendar in your schema . So its better to combine the Product and internetsale table into one table and then use the dates field to connect to the calendar table