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_For...
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
Idrissshatila
Super User
Super UserHello Anonymous,
it should be something like this
dims
Dim_Clients
Dim_Products
Dim_Formats
Dataset 1
FactSalesDataset1
Dataset2
FactSalesDataset2
Dim_Calendar