How to link two Star Schemas?

[paolo_troia]

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

[Idrissshatila]

Hello @paolo_troia ,

when you have two datasets that you want to filter, you should have the same dim tables that are connected to both facts.

[paolo_troia]

Hi @Idrissshatila 

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]

Hello @paolo_troia,

it should be something like this

dims

Dim_Clients

Dim_Products

Dim_Formats

Dataset 1

FactSalesDataset1

Dataset2

FactSalesDataset2

Dim_Calendar