1 Reply Latest reply on Nov 1, 2012 10:01 PM by Ramesh Reddy

    flattening parent child hierarchy

    Nelson Yap Newbie

      Hi

       

      We have a requirement to flatten a parent child relationship into a hierarchy for reporting. In oracle this can simply be done in the extension of SQL by using connect by and prior to. I would like to find out if it is possible to do this in teiid instead ? This will add a lot of benefit if dealing with non oracle sources.

       

      Thanks