(Peter Zaitsev) In many Search/Browse applications you would see main (fact) table which contains search fields and dimension tables which contain more information about facts and which need to be joined to get query result.
Read More - Register for Free Membership