What is your approach to structuring SQL queries when joining large transactional tables with dimension tables?