RE: EXT :Informatica Workflow name tracking via MODULE/ACTION fields
Date: Thu, 5 Sep 2013 16:49:34 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0D1BF217_at_XMBVAG74.northgrum.com>
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
Received on Thu Sep 05 2013 - 18:49:34 CEST