We use this solution as our data warehouse. It handles our analytics and we have power users connected.
We use this solution as our data warehouse. It handles our analytics and we have power users connected.
Eighty percent of the ETL operations have improved since implementing this solution. Complex queries are challenging to improve.
This most valuable feature is the database designer, which helps significantly improve our storage footprint.
There is serious performance degradation for large datasets. Fact-to-fact joins on multi-billion record tables perform poorly. Star schema joins also perform poorly if the fact tables reach more than one billion records and the dimension tables reach more than one million records.