topic Join Multiple Dimensions and Facts with more than one id field and how to eliminate synthetic keys in App Development

Join Multiple Dimensions and Facts with more than one id field and how to eliminate synthetic keys

kar301281 — Sat, 16 Nov 2024 02:34:46 GMT

Hi

I have multiple dimension table where each dimension tables has 4 keys and the fact table also has the same and it is creating as many synthetic keys for each.

For ex:

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

TableA ( DIMENSION1)

Id1

id2

id3

id5

E

F

TableB ( DIMENSION2)

id1

id2

id3

id4

G

H

FACT(F1)

id1

id2

id3

id4

Revenue

sales

FACT(F2)

id1

id2

id3

id4

Loss_revenue

Loss_sales

Etc.

How we can do the datamodeleing eliminating synthetic keys for the same. give some examples where if any one handled multiples keys between multiple dimension and multiple facts and removing synthetic keys.