July 6, 2011 at 4:19 am
Hi,
This is my question can anyone help me to resolve this:-)
1000 rows in the fact table
5 rows in the Geo dimension table
50 rows in the product dimension table
100 rows in the calendar dimension tables
2000 rows in the customer dimension table
When I join fact and geo table what will be the maximum rows
When I join fact and customer table what will be the maximum rows I get
July 6, 2011 at 9:29 am
What type of join you are doing? It would probably also depend on the attribute(s) you are joining on and their values.
July 6, 2011 at 12:21 pm
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
July 10, 2011 at 10:23 pm
hi,
Thanks for your reply..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply