Is it better to combine multiple fact tables with a primary key or with a merge operation? @bat @rbankula
From Optimizing Query Performance and Resource Pool Tuning.
Keep them separate.
Pick one of them as your main table and extend that with the columns of the other table with the https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTables.htm feature.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.