SEO

#1 (**permalink**) 02-25-2008, 06:05 AM

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.

#2 (**permalink**) 02-25-2008, 06:05 AM

"John Burke" <abc@def.com> wrote in message
news:Xns981676A241B81abcdefcom@216.196.97.136...
> 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.

John,
If you post this in the App Express forum over at Oracle's site, I am sure
you will get a much better response, the developers of the product and MANY
users exchange ideas and issues there!!

#3 (**permalink**) 02-25-2008, 06:06 AM

--
-- Oracle Application Express - Main Web Site.
--
http://www.oracle.com/technology/pro...ess/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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to trigger Informatica from OAE ?