Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Datamart design for Cognos Impromptu 7

    I have a datamart design that is fully snowflaked and I don't think it needs to be. The product that will be using the datamart is Cognos Impromptu v7. I'm under the believe that Cognos works better with a star schema vs. a fully snowflaked model. Can any offer an opinion? Thanks.

  2. #2
    Join Date
    Dec 2003
    Posts
    2

    Thumbs up Re: Datamart design for Cognos Impromptu 7

    Originally posted by bullt9s
    I have a datamart design that is fully snowflaked and I don't think it needs to be. The product that will be using the datamart is Cognos Impromptu v7. I'm under the believe that Cognos works better with a star schema vs. a fully snowflaked model. Can any offer an opinion? Thanks.
    well dear friend I have used cognos for developing a cube and report too so the best way i felt to use it after designing a star schema and one should always avoid snok flaking as much as possible because that way i think you are again moving back to normalization mode which is strictly not followed in DW design.
    Regards,
    CogHunt

Posting Permissions

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