Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to trigger Informatica from OAE ?

Re: How to trigger Informatica from OAE ?

From: Pete <prpotocko_at_gmail.com>
Date: 7 Aug 2006 10:55:56 -0700
Message-ID: <1154973355.964287.258200@i3g2000cwc.googlegroups.com>

--
--	Oracle Application Express - Main Web Site.
--
http://www.oracle.com/technology/products/database/application_express/index.html

Then you could go into the Application Express Forum and ask the
question.

...Pete Potocko


John Burke wrote:

> Hello
>
> We will be using Oracle Application Express (OAE) to upload a tab
> delimited text file. After performing some simple validations on the
> data uploaded, OAE will write the data rows to a table in the Oracle
> database.
>
> At this point, we would like to kick off an Informatica mapping which
> will read the data from this table, perform some more validations and
> transformations, and load it into the final tables.
>
> We want as small a delay as possible between the time the user uploads
> the file and the time it is loaded into the final table(s) in the
> database.
>
> The reason for not developing stored procedure(s) is that we want to
> leverage the vast Informatica code that already exists.
>
> What are the different ways (assuming there are some) that an OAE screen
> could trigger an Informatica mapping ?
>
> Your responses to the newsgroup are greatly appreciated.
>
> Thank you.
Received on Mon Aug 07 2006 - 12:55:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US