- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dimension and Fact contain same fields
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Some what we are walking good approach. Here, I don't use QUALIFY Statement unless needed..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
then what should i have to used beacuse it contain synthetic key
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In your model, I haven't seen any Synthetic Key. Any way, May be create Link Table to achieve this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
without using any function i load a script then it look like ↓
product(dim) and internetsales(fact) get autoconcatenate.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to create link table it required more than one fact table but in my model only one fact table is there.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ok,btw thank you so much..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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