Java Developer learning PL/SQL [message #351626] |
Wed, 01 October 2008 15:01 |
cperren
Messages: 1 Registered: October 2008
|
Junior Member |

|
|
I'm not sure if my ETL process is correct in terms of using table functions and pipes for translating data from external tables. Please advise..
I need to create a 4 step translation before writing to multiple staging tables. Should I pipe the output from 1 translation function into the next translation function. If so, how do I pass the pipe data into the second function? Or do I call the second translation function step from the first translation step and so forth...
Currently, I'm able to pass a cursor using a SQL query against the external table and return a pipe result. The problem is that I do not know how to take the resulting pipe data and pass it into the second transformation. Or may I should just make an explicit call to the second transformation from with the first function.
Also, should I query and create a cursor for the external tables though SQL or as a PL/SQL function?
Kind Regards .. and Many Thanks
Chris Perren
|
|
|