Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Valued 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
Highlighted
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.

View solution in original post

17 Replies
Highlighted
Valued Contributor III

Re: DataModel

what is the best approach?  Tresesco B

Highlighted
MVP & Luminary
MVP & Luminary

Re: DataModel

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

- Marcus

Partner
Partner

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

Highlighted
Valued Contributor

Re: DataModel

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


my advise is to use single column..

Highlighted
Valued 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.

Highlighted
Valued Contributor

Re: DataModel

Fine

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

Highlighted
Valued 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

Highlighted
Valued Contributor

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;

Highlighted
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.