This content has been marked as final. Show 5 replies
See if this helps you
Hi,1 person found this helpful
Yes but there is some restrictions...
Show me an example about what you need.
Can be used at any ODI version.
Thanks for your reply.
We would need to implement recursive SQL for querying information from parent-child relationships.
The following SQL code shows an (Teradata SQL) example:
WITH RECURSIVE RECTBL(CHLD, PRNT, LVL)
SELECT CHILD, PARENT, 1(INTEGER)
WHERE CHILD = 'G'
SELECT MYTBL.CHILD, MYTBL.PARENT, RECTBL.LVL + 1
FROM RECTBL INNER JOIN MYTBL
ON RECTBL.PRNT = MYTBL.CHILD
AND RECTBL.LVL <= 5
SELECT CHLD, PRNT
ORDER BY LVL
no alternative in this case. As far as I know, it will be necessary KM customizing for this and it's complex...
Thanks for the information!