Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Contributor III

DataModel

Hi All,

i have 3 tables with same columns    so i want to create a data model  as star schema     how can i do this?     i dont want single table data model .....  i want star schema model.

TableA

A

B

C

D

E

TableB

A

B

C

D

E

TableC

A

B

C

D

E

Thanks

Sony

Tags (1)
1 Solution

Accepted Solutions
balabhaskarqlik
Honored Contributor

Re: DataModel

From the Above, Separate dimension tables created like below:

TableA, TableB, TableC are the separate Dimension tables, connected by Key(A).

Like in the below image, Sales, Docs, VisitActivity are three Dim tables connected by DocID dimension.

17 Replies
soniasweety
Contributor III

Re: DataModel

what is the best approach?  Tresesco B

Re: DataModel

Just with the given information the single table would be the best. Why should it be a star-scheme?

- Marcus

thabang_petje
Contributor III

Re: DataModel

Hi,

Why does it need to be a star schema?

You can concatenate into one table. If you really need a star schema, create the keys you want to use and the rename the rest of the fields to be different from the other tables

arvind1494
Contributor III

Re: DataModel

If you have 3 tables with same columns then why do you want star schema


my advise is to use single column..

soniasweety
Contributor III

Re: DataModel

the use requirement is  he want to see as  star schema not in single table.

like  in Qvd generator only   we need to create  seperate  fact and dimension tables.

arvind1494
Contributor III

Re: DataModel

Fine

then tell me which column are key's in that 3 tables

soniasweety
Contributor III

Re: DataModel

in the above example

A  is ID column which is key in all three tables

rest are dim and measure columns

arvind1494
Contributor III

Re: DataModel

TableA:

Load A as key,B,C,D,E from TableA;


TableB:

Load A as key

B AS B.B

C AS B.C

D AS B.D

E AS B.E FROM TableB;


TableC:

LOAD

A AS KEY

B AS C.B

C AS C.C

D AS C.D

E AS C.E FROM TableC;

vishalpujari22
New Contributor III

Re: DataModel

My approach is

create star schema

if u don't want single table in this case rename field name treat as separate table.