Hi team, I am new in Pinot. I have a question about modeling tables. I have one real-time table and one dimension table, the dimension table is larger than 200MB.. Is there a solution/best practice how to handle lookup\joins with dimension tables that are larger than 200MB? thanks 🙏

Essentially the dimension table needs to fit in every server. So depending on size of table you may need to ensure enough memory