Hi,
I thought i'd post this. I think I found a solution/workaround to the problem mentioned.
Thought we can use a user-defined insert SQL in the Oracle Stage by leveraging the LEVEL pseudocolumn in the Oracle d/b. Its pretty handy..
syntax can be found here:
http://www.psoug.org/reference/connectby.html
Deriving different Levels
Moderators: chulett, rschirm, roy
Hi Havoc,
The option that you found out is more simple. You can just group by based on Parent Dept Child Dept, and get the max(LEVEL) with order by max(LEVEL) during extraction. You can just concatenate subsequent row until you find a change in value using stage variable. Though the LEVEL is in reverse order when compared to you expectation, it is quite simple for your requirement.
The option that you found out is more simple. You can just group by based on Parent Dept Child Dept, and get the max(LEVEL) with order by max(LEVEL) during extraction. You can just concatenate subsequent row until you find a change in value using stage variable. Though the LEVEL is in reverse order when compared to you expectation, it is quite simple for your requirement.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'