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