Results 1 to 2 of 2

Thread: Hi

  1. #1

    Smile Hi

    Hi, How will u implement many to many relationship in star schema model?


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    139

    Re: Hi

    Hi,

    Defining a Many-to-Many Relationship and Many-to-Many Relationship Properties

    The many-to-many dimension relationship defines an association between a dimension and a measure group by specifying an intermediate fact table that is joined to the dimension table. An intermediate dimension table is in turn joined to both the intermediate fact table and to the fact table on which the measure group specified by the relationship is based. The many-to-many relationships between the intermediate fact table and both the dimension table in the relationship and the intermediate dimension create the many-to-many relationships between members of the primary dimension and the measures in the measure group specified by the relationship.

    Many-to-many dimensions expand the dimensional model beyond the classic star schema, and support complex analytics when dimensions are not directly related to a fact table.


    Regards

    NIkhil Rattan


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact