Re: EXT :Informatica Workflow name tracking via MODULE/ACTION fields

From: Job Miller <jobmiller_at_yahoo.com>
Date: Thu, 5 Sep 2013 12:32:11 -0700 (PDT)
Message-ID: <1378409531.90481.YahooMailNeo_at_web126104.mail.ne1.yahoo.com>

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_at_ngc.com> To: "scott.l.mcmillan_at_seagate.com" <scott.l.mcmillan_at_seagate.com>; oracle-l <oracle-l_at_freelists.org> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 05 2013 - 21:32:11 CEST