Need help Data Modeling

[#1]

Hi,

I have 4 tables. PDV,INC,SUI,DMM.

               n°PDV     n°Incident   n° suivi

PDV             x

INC              x                  x

SUI              x                  x              x   

DMM           x                  x              x

How can create the star schema with fact table like DMM and dimension around like PDV, INC, SUI ?

Thanks for your help.

[sushil353]

Please find the attached file.

see if it is working for you.

HTH

Sushil

[sujeetsingh]

Hi Jud,

It is just not to ask for star schema ,but you shoyld first get familiar with schema ,,,fact Dimension...and all aothe data warehousihg terms.

So i am giving you some link and go through them all and then analyse a best plan for your structure .

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

http://community.qlik.com/servlet/JiveServlet/previewBody/1881-102-1-1865/Best%20Practices%20in%20Da...

One of the easy way for your modell is just nPDV as same in all and load all table with same name column renamed.

[#4]

Thanks for your help Sushil.

[#5]

Hi Son ofSardar.

Thanks a lot for your link.