Please check with following possibilities, I have consider fact and geo tables

1) Cross Join -- It will give you cartesian product of two tables = 1000*5=5000 rows

2) Inner join --It will give you only matches from both the tables

a) = 5 -- if all five matches

b) < 5 -- if no duplicates

c) >= 5 -- if there are duplicates

d) 0 -- No matches

3) Left join -- It will give you all matches from left table even if there are no matches in the right table

a) = 1000 -- all matches

b) >= 1000 -- with duplicates

4) Full outer join -- It will give you matches as well as nonmatches from both the tables

a) >= 1000