Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS Expand / Collapse
Author
Message
Posted Wednesday, July 06, 2011 4:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 01, 2013 3:34 AM
Points: 59, Visits: 148
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
Post #1137119
Posted Wednesday, July 06, 2011 9:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 08, 2011 3:29 PM
Points: 3, Visits: 9
What type of join you are doing? It would probably also depend on the attribute(s) you are joining on and their values.

Post #1137413
Posted Wednesday, July 06, 2011 12:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:59 AM
Points: 11, Visits: 160
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
Post #1137562
Posted Sunday, July 10, 2011 10:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 01, 2013 3:34 AM
Points: 59, Visits: 148
hi,


Thanks for your reply..
Post #1139512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse