Informatica Workflow name tracking via MODULE/ACTION fields

From: Scott L McMillan <scott.l.mcmillan_at_seagate.com>
Date: Wed, 4 Sep 2013 16:39:33 -0600
Message-ID: <CACdHRt-++_NCRpz8D_8JG=AmXq-xdr0LV7E2FBC1tRQtx5BNHQ_at_mail.gmail.com>

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 Received on Thu Sep 05 2013 - 00:39:33 CEST