Archives of the TeradataForum

Message Posted: Mon, 04 Oct 2010 @ 19:52:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

John

I was hoping someone wouldn't challenge me on why we are doing that :) but effectively it is this:

It's part of our dimensional design and the avoidance of left outer joins for dimensions which don't apply to a fact record, but still need to be reported on.

Thanks Babar, for your answer... I will test this in the morning

Regards

Simon

	<Prev	Next>		<<First	<Prev	Next>	Last>>