Showing posts with label Universe Design. Show all posts
Showing posts with label Universe Design. Show all posts

Tuesday, October 20, 2009

How to Add to the List of Existing Connections

Posted by sapbotopics

Read more »

How to Add to the List of Existing Connections

Posted by sapbotopics

Read more »

Thursday, May 22, 2008

What is a Chasm Trap

Posted by sapbotopics

What is a Chasm Trap

Simply put: A chasm occurs when a series of joins crosses a many >- one -<>

A >- B -<>

If I were to write a query that spanned all three of those tables the data from table A and C would be duplicated and measure values would be inflated. The inflation factor can be determined by counting the number of rows from the left that match a particular key and multiplying by the number of rows on the right....... for more details

Read more »

What is a Chasm Trap

Posted by sapbotopics

What is a Chasm Trap

Simply put: A chasm occurs when a series of joins crosses a many >- one -<>

A >- B -<>

If I were to write a query that spanned all three of those tables the data from table A and C would be duplicated and measure values would be inflated. The inflation factor can be determined by counting the number of rows from the left that match a particular key and multiplying by the number of rows on the right....... for more details

Read more »

Subscribe to: Posts (Atom)