This content has been marked as final. Show 7 replies
is there any method of joining without populating... zip..
I'm thinking to create alias dim1, alias dim2 ... which gets joined to fact... on 2 different conditions.
one as dim1.county = fact1.county
and another as dim2.city = fact2.city
And, merge the dim1 and dim2 as dim in business layer... with (different sources) what do you say.. any ideas..??
And, then apply left or right joins as i like..
Edited by: GRK on Jan 25, 2013 8:25 AM
Since you are using 10g I would suggest these:
1) Use any join condition in Physical layer
2) In BMM layer on fact create a new logical collumn IfNull(DepartmentCity,'Unspecified')--> Named as City
and do the same for other IfNull(DepartmentCounty,'Unspecified')--->Named as County
3) Create Logical foreign key join between Fact and dim
with join conditions
Dim.Department county = Fact.County
Dim. Department city = Fact.City
BMM join will be used in the query and join in physical layer will be ignored.
Edited by: Srini VEERAVALLI on Jan 25, 2013 10:35 AM
Have done something else? What was the solution?
Edited by: Srini VEERAVALLI on Jan 25, 2013 2:41 PM