Junk dimensions are often misunderstood and avoided. And they should not be. Junk dimensions offer a strategy to remain true to dimensional intentions and to better focus one's design and sometimes ...
RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.