Home Forums Data Warehousing Strategies and Ideas Using "constant union" dimension views instead of dimension tables - good/bad idea? RE: Using "constant union" dimension views instead of dimension tables - good/bad idea?

  • March 8, 2011 at 1:03 pm

    #1296104

    Re the discussion:

    Holger I (3/8/2011) wrote

    I remember a discussion like this, where Joe Celko suggested using views for simulating "small tables". There were some pros and cons inside this discussion and I think it'd be helpful, if you find it. ...

    Googling for "celko "VIEW defined with a table constructor"", I found a few places - but none had a discussion :-(.