Hi gurus,
I have star schema model in my project.
I need a suggestion
i have 1 fact and 4 dimension in my scnerio,i have dimension named control dim,sun dim,accont dim and fors dim and fact deal.
the query i need is to get the result from account dim,deal fact and sun dim,but i am getting query in this way acount dim,deal fact and control dim,how can i make sun dim to get involved in this query
Thanks in advance
k.m
If you fetch no data from the sun dim, how do you expect to get this dimension to participate in the join execution?