Forum Discussion
Relationships slow down very much the performance
Hello, I thought that the performance is so weak due to the measures applied. But I found out that the attributes from the dimensions table slow down the performance very much. Here is my model...
Speed increased very much after using only one fact table. In the same term the size decreased dramatically as the key with high cardinality that links both fact tables diminished as well.
The joining is done directly in oracle DB source.