Hi Mrao, Thank you for the update. Fact A table has updates on almost daily basis and FactB table has weekly updates. FactB table takes around 4 hours to get updated. As I wanted the consolidated output with good performance, I thought pre-join would be the good option. But it does not work to fetch...

Hi All, I am new to vertica and I want to implement below case scenario with Pre-Join projection. Please suggest how can i achieve this. I have two tables like FactA(CustomerID (PK),Units) &FactB(CustomerID (FK),Sales) and the data is avail like below: FactA FactB CustomeID Units CustomerID Sales --...