Re: EXT :Informatica Workflow name tracking via MODULE/ACTION fields
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: "peter.schauss@xxxxxxx" <peter.schauss@xxxxxxx>, "scott.l.mcmillan@xxxxxxxxxxx" <scott.l.mcmillan@xxxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Sep 2013 12:32:11 -0700 (PDT)
Informatica allows you to execute an initiation block at the beginning of an
ETL process.
We've used that to set up session specific tracing, module/actions, and session
specific parameters.
No reason you couldn't use that pre-initiation block area to manually set
Module/Action with the name of the map executing.
Job
________________________________
From: "Schauss, Peter (ESS)" <peter.schauss@xxxxxxx>
To: "scott.l.mcmillan@xxxxxxxxxxx" <scott.l.mcmillan@xxxxxxxxxxx>; oracle-l
<oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, September 5, 2013 12:49 PM
Subject: RE: EXT :Informatica Workflow name tracking via MODULE/ACTION fields
Scott,
The version of Informatica ETL which I worked with several years ago logged the
ETL steps in a table called W_ETL_RUN_SDTL providing start and stop times for
each step. I was able to monitor the progress of the ETL by querying this
table. The currently running step would be one which had a null stop time.
HTH,
Peter Schauss
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Scott L McMillan
Sent: Wednesday, September 04, 2013 6:40 PM
To: oracle-l
Subject: EXT :Informatica Workflow name tracking via MODULE/ACTION fields
Hi,
Our Oracle DBA Team is researching options to achieve the below goal - How can
the Informatica ETL application be setup so that the ETL "WorkFlow name" &
ETL "Session name" pass into the Oracle database 'MODULE' field & 'ACTION'
field when connecting to the target DB, for tracking purposes in views like
V$SESSION?
NOTE: Our 'custom' applications use the following embedded code for
the same purpose: exec dbms_application_info.set_module('xxx','xxxx');
We previously created an "Informatica Tech Support" SR ticket
on this topic, but did not get a solution.
Thanks for your time,
Scott.
-----------------------
Scott L. McMillan
Seagate - Longmont, CO.
Oracle 8i/9i Certified DBA
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
