Home » SQL & PL/SQL » SQL & PL/SQL » Java Developer learning PL/SQL (Oracle 10.2.0.1)
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

Previous Topic: date and time
Next Topic: help with COUNT function
Goto Forum:
  


Current Time: Wed Feb 12 05:53:36 CST 2025