DataModel

[soniasweety]

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

[soniasweety]

what is the best approach?  Tresesco B

[marcus_sommer]

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

- Marcus

[Anonymous]

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]

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

my advise is to use single column..

[soniasweety]

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]

Fine

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

[soniasweety]

in the above example

A  is ID column which is key in all three tables

rest are dim and measure columns

[arvind1494]

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]

My approach is

create star schema

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