Forum Discussion
How to link two Star Schemas?
Hi,
I have two similar datasets (Dataset1 and Dataset 2) and I created two separate star schemas.
The resulting tables are:
Dataset 1
DimDataset1_Clients
DimDataset1_Products
DimDataset1_Formats
FactSalesDataset1
Dataset2
DimDataset2_Clients
DimDataset2_Products
DimDataset2_Formats
FactSalesDataset2
Dim_Calendar
How can I create a single Star Schema in order to merge the two datasets and create calculated fields from both datasets?
I don't know if it's the correct way when you have two datasets to link.
Thanks in advance
Paolo
3 Replies
Hello Anonymous ,
when you have two datasets that you want to filter, you should have the same dim tables that are connected to both facts.
thanks for your rapid feedback!
How can I have the same Dim tables if I have two datasets, two star schemas and starting from the tables below?
If this tables created is wrong, could you please tell me step by step the right method to use? Is there also a video on youtube that explain step by step this problem?
Dataset 1
DimDataset1_Clients
DimDataset1_Products
DimDataset1_Formats
FactSalesDataset1
Dataset2
DimDataset2_Clients
DimDataset2_Products
DimDataset2_Formats
FactSalesDataset2
Dim_Calendar
Thanks
Hello Anonymous,
it should be something like this
dims
Dim_Clients
Dim_Products
Dim_Formats
Dataset 1
FactSalesDataset1
Dataset2
FactSalesDataset2
Dim_Calendar
