Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    14

    Unanswered: What is structure of SQL Query to Resolve Chasm Trap

    Database MS SQL Server 2005

    Hi Friends,

    My Database has two Fact tables and one Dimension table. Some complex calculation formulas involves both the fact tables and dimension table. But it creates traps and shows wrong result set.

    Can anyone please suggest solution how this can be resolved?
    What would be structure of SQL Query

    Any help is appreciated.

    Thanks in advance.

    Regards,
    Ashish

  2. #2
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Most people won't want to do your homework for you.

    Think about what you know about connection traps and how to avoid them.

  3. #3
    Join Date
    Sep 2008
    Posts
    14

    Resolving Chasm Trap in SQL Query.

    Hi dportas,


    Thanks for your reply and sorry for not posting it in detail.

    What I have tried -
    1. I tried using Fact table 1 and Dimension table and Fact table two with Union ALL.
    2. As per one article on net, I tried combination of left outer join.

    But this also not helped. So looking if any one has resolved or knows a way toresolve it.

    Regards,
    Ashish
    Last edited by Ashish Bhalerao; 04-14-09 at 06:44.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Ashish Bhalerao
    So looking if any one has resolved
    yes, i have

    i can't help you with yours, however, because unfortunately my beta copy of Microsoft® CrystalBall© is down at the moment, so i cannot see your tables and therefore cannot show you how

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •