Forum Discussion

Jlicht's avatar
Jlicht
Frequent Visitor
7 years ago

How to transform a reverse star schema into a normal star schema

Greetings Experts,    I have uploaded my data an the automatic relationship has sorted my tables below. From the traditional star schema, it looks to be a "reverse star schema". Fact tables are the...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Jlicht 

I'm afraid there's no quick way to achieve that.You may transform them manually.

Regards,

Jlicht's avatar
Jlicht
Frequent Visitor
7 years ago

v-cherch-msft  That is sad to hear, but I guess some data is build like that. Do you know how I would go about manually editing the data to fit a star schema in this situation? Just as a general process?