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.
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.
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
Load A as key,B,C,D,E from TableA;
Load A as key
B AS B.B
C AS B.C
D AS B.D
E AS B.E FROM TableB;
A AS KEY
B AS C.B
C AS C.C
D AS C.D
E AS C.E FROM TableC;