Topic
  • 4 replies
  • Latest Post - ‏2013-01-08T05:01:12Z by yuvran
yuvran
yuvran
101 Posts

Pinned topic Modeling in Framework Manager - Join two facts

‏2013-01-02T11:53:28Z |
Hi,

I have 4 dimension tables A, B, C, D and 2 fact tables F1 and F2.

A, B, C has a relationship with F1.
A, B, C, D has a relationship with F2.

Also there is a relationship between F1 and F2.

Could anyone suggest me what type of modeling is the best way for this scenario.

Thanks,
Yuvarani.
Updated on 2013-01-08T05:01:12Z at 2013-01-08T05:01:12Z by yuvran
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Modeling in Framework Manager - Join two facts

    ‏2013-01-03T07:24:08Z  
    Hi,

    You should never join two facts. Please refer attached model for your answer.

    Regards,
    Manish Tirpude
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Modeling in Framework Manager - Join two facts

    ‏2013-01-03T07:25:33Z  
    Hi,

    You should never join two facts. Please refer attached model for your answer.

    Regards,
    Manish Tirpude
    Attached model
  • yuvran
    yuvran
    101 Posts

    Re: Modeling in Framework Manager - Join two facts

    ‏2013-01-03T09:04:01Z  
    Attached model
    Hi,

    I didnt find the attachment. Please repost it.
  • yuvran
    yuvran
    101 Posts

    Re: Modeling in Framework Manager - Join two facts

    ‏2013-01-08T05:01:12Z  
    Attached model
    Hi Manish,

    Please attach the attachment again. I didnt find that.

    Thanks,
    Yuvarani