Informatica Power Center : Update Master DB refresh interval

Master DB refresh interval can be updated using the update domain options. The refresh interval typically updated to avoid frequent shutdown due to following error.

Error

FATAL [Domain Monitor] [DOM_10094] Cannot update the data for the master gateway node [node01_bi] within the refresh interval time [96000]. The node will not continue as a master gateway node. Verify that the connection to the domain configuration repository database is valid.

Master DB refresh interval

Use following command to update the refresh interval.

Informatica 9.6.1 : MX Views Queries

Query to get Run timings for Workflow Instances

SELECT
WORKFLOW_NAME,
INSTANCE_NAME,
START_TIME,
END_TIME,

Informatica 9.6.1 : Import objects into Informatica repository

Stepwise illustration on how to import objects using Informatica powercenter repository manager.

Step 1 :

Log into repository manager and select "Import objects".

Informatica Powercenter Domain Upgrade : 9.5.1 to 9.6.1

Download powercenter installation software from Informatica site.

http://download.informatica.com

During the software purchase, Informatica will provide a site link, user ID, and password to access the Informatica electronic software download site. Here are the options for download.

Informatica 9.6.1 Node management : Starting or Stopping Services on Linux

Here are the steps.

Go to Informatica installation directory.

• infaservice.sh startup
• infaservice.sh shutdown

Informatica Powercenter Common Errors : TE_7020 Internal error. The Source Qualifier contains an unbound field

Error Message

Severity Thread Message Code Message
ERROR MAPPING TE_7020 Internal error. The Source Qualifier [SQ_DW_CUSTOMER_DIM] contains an unbound field [OTHER_NAME]. Contact Informatica Global Customer Support.

ERROR MAPPING TE_7016 Internal error. Failed to allocate or initialize transformation [SQ_DW_CUSTOMER_DIM]. Contact Informatica Global Customer Support.

Informatica 9.6.1 : MX Views query for list of tables

• Query on MX views for list of all tables used in the ETL code

SELECT TABLE_NAME, TABLE_TYPE FROM
(
---- Source Tables ---
SELECT DISTINCT 'Source Table' as TABLE_TYPE, PARENT_SOURCE_NAME TABLE_NAME FROM REP_ALL_SOURCES
UNION