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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy