Hi Team,
Need your recommendation on this one.
We are planning to bring in a dimension table for quick LOOKUP functionality where we JOIN our analytics table with this dim table.
1. Since dimension tables are loaded in each server's memory for a given tenant ID, do we need replication-factor >1 here? Since its replicated on each node by default, is RF of any significance here?
2. Our calculation says we would be needing ~1-2 GB memory for this dimension table. Is there any constraint on the size? Or its just controlled by the "quota" config?