Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. srokes

    Modeling Technique

    I am curious of how many people are modeling using a "Dimensional" modeling/star schema design. How many are still building in 3rd normal form? Any specific easily presentable benefits of one over the other?
  2. srokes

    Fact Records/Oracle/Indexes

    Yes, we will be partitioning the data along monthly processing date. But the over all table will have billions of rows and each partition will have 100 to 200 hundred milliion rows per month. I am wondering about a table and not each partition.
  3. srokes

    Span/Occurance/Condition/Value codes

    Has anybody worked with SPAN/OCCURANCE/CONDITION/Value codes from a medical claim in a star schema/dimensional model?
  4. srokes

    Fact Records/Oracle/Indexes

    But was that in one table?
  5. srokes

    Fact Records/Oracle/Indexes

    Does anybody have billions of rows in a fact table? Does anybody have billions of rows in a fact table and using oracle?
  6. srokes

    Diagnosis Dimension Modeling

    ok, can you tell me approximately how many records you are in your bridge table and the claim fact table?
  7. srokes

    Diagnosis Dimension Modeling

    I am working on a dimensional model and dealing with the wonderful world of claims and diagnosis. I have come across a few solutions, but was wondering about other solutions. I have read R.Kimball and saw the bridge concept. I was not sure if anybody has implemented this or any other...

Part and Inventory Search

Back
Top