Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
balabhaskarqlik

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
soniasweety
Master
Master
Author

what is the best approach?  Tresesco B

marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

thabang_petje
Partner
Partner

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
Specialist
Specialist

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


my advise is to use single column..

soniasweety
Master
Master
Author

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
Specialist
Specialist

Fine

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

soniasweety
Master
Master
Author

in the above example

A  is ID column which is key in all three tables

rest are dim and measure columns

arvind1494
Specialist
Specialist

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;

agastya
Creator
Creator

My approach is

create star schema

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