4 thoughts on “Connect by to generate rows”

  1. note that in production, I would recommend creating “lookup” tables if appropriate.

    For datawarehouse, prefer using dimension tables, as described in the
    datawarehouse guide
    , if I need to outer join with each day of the year, or each minute, I create the relevant table and insert each values than join with that fix table. It can be partitioned, or IOT, and it is highly scalable.

    Generating the rows is not “better” than using a fixed lookup table. Check what is the most appropriate.

    thanks for your comment, I greatly appreciate

  2. Sali Laurent hope you yre doing fine. Your profile is at moment not complete. So it is a bit difficult to accuit you.

    Thanks Ben.

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>