What are best practices for combining huge datasets in Domo?
We have been using Domo for nearly a year now and are heavily utilizing DataFusion and Dataset Views to accomplish joining dimension tables to our primary fact tables. By the time we have joined everything we need, it is not uncommon to be looking at 300-800 columns and 50-100 million rows across 5-6 datasets. We often see performance issues with these tools however, such as not being able to edit/preview the datafusion or dataset view. We have worked with Domo to "optimize" these to the extent they can and are often still running up against a scenario where it works as long as we don't want to edit or make any changes. What are others using to transform/join massive tables like this in Domo?
Additional Info: These are mostly large ERP datasets coming in via workbench. They must be joined separately (not during ingestion) as these are dynamic rollups such as product hierarchy, item attributes, fiscal calendar offset.
Any advice or experiences is much appreciated!