Former un schema en étoile

[intergnek]

Hello,

I am looking for a way in my loading script to make a star schema.

Indeed I have two fields (Ville and Mois) that are repeated in all the tables and I want to arrange to create a table containing these two fields so that all the other tables are connected to this table created.

Thank's!

[YoussefBelloum]

Hi,

did you try to concatenate these tables ?

[intergnek]

it's an example, otherwise I have several tables containing many fields.

I think to find bad results by doing so

[YoussefBelloum]

You can concatenate, you can create a linktable...

But every technique should be implemented correctly, otherwise youll have bad results.

Give it a try and see the results

[intergnek]

Ok Thank you Youssef,

Ok I'm trying