Data modeling in star

[#1]

Hello,

I am writing to you because I want to model my app like a star model.

Actually, my structure is like :

I think it will be good to transform it with the method of hollow table to obtain :

But what I don't understand is how can I do that, considering that I already have relations between tables, like the field "Section".

Do I have to rename them ?

Thanks for your help

[#2]

Hello,

Thanks for your reponse.

Can you help me for a thing. In fact, OrderLine or Order are join tables.

To do the key on a join table, I have to reload exclusively the complete table ?

Because if I do something like :

Order_tmp:

LOAD

  [Order Number],

  [Order Supplier];

SQL

SELECT FROM;

Left Join

Order_tmp2:

LOAD

  [Order Number Line],

  [Order Designation];

SQL

SELECT FROM;

Order:

LOAD

  [Order Number],

  [Order Supplier],

  [Order Number Line],

  [Order Designation]

Resident Order_tmp;

Drop table Order_tmp;

---

With this I can get back the Order table in my script.

Do you know how to do ?

Thanks lot !

[crusader_]

Hello Olivier,

If you do such thing

Order_tmp:

LOAD

  [Order Number],

  [Order Supplier];

SQL

SELECT FROM;

Left Join

Order_tmp2:

LOAD

  [Order Number Line],

  [Order Designation];

SQL

SELECT FROM;

you will get outer join instead of left join.

Also try to modify your datamodel as Mahesh suggested if possible on your dataset.

Regards,

Andrei

[Yousef_Amarneh]

Are you sure that your join is correct? if so then you have to make the key after loading the complete table.

[#5]

Hello,

Really not sure no

I'm stuck with this program, I don't have the time for the moment to see it, but I will try to resume and see with key or with mahesh proposal !

Thanks!

[Yousef_Amarneh]

if you want just send me the a script that extracting the data from the data source as is without join and I will try to make it for you