data modeling

[Anonymous]

Hi all,

How to create data modeling with star schema .pfa

[prieper]

Would you please generalize your problem, think that not everyone is willing to download 15MB and write an application for it ...

Peter

[HirisH_V7]

Did You tried all tables as Left Join between them !

Whats the issue !

[Anonymous]

Actually am confused that what function I should apply on that as you see all attachments have same field but values are not same and I am trying to do star schema on it.

Only field safety xls is different and all fields also different.can you please suggest what will I have to do here.

[HirisH_V7]

Hi ,

I loaded all of your files, Can you rename and justify the fields. Create one common key for every Table .

Check PFA

[MarcoWedel]

H‌i,

please post your current result together with one specific question.

thank you

regards

Marco