Hello, I've searched, but have not found the definitive answer. Can you tell me, is it possible to create a query or loop in Talend to return the results of a hierarchical query? This is the case where you have a table with a foreign key pointing to itself. It may be N levels deep. The table might look like: Employee --------------------------- employee#|manager# 1 2 2 3 3 null where manager# points back to employee#. Oracle uses a "connect by" syntax for this. I am using JDBC
Hi Try to use tOracleRow and edit sql with "connect by". Check "Propagate QUERY's recordset" of tOracleRow->Advanced Settings. Then pass the RecordSet to tParseRecordSet component. Use tParseRecordSet to retrieve columns. Regards, Pedro
I need the same thing. I want to implement the recursive operation in Talend, not the Database. Basically, I want to start at the leaf (employee) and add manager rows until the top node is reached. For those of you familiar with CTE in MS SQL server, I want to implement the same basic functionality using talend objects.