Saturday, October 3, 2015

Informatica 9.6.1 : MX Views Queries

Query to get Run timings for Workflow Instances

SELECT
WORKFLOW_NAME,
INSTANCE_NAME,
START_TIME,
END_TIME,

Tuesday, September 8, 2015

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".

Saturday, September 5, 2015

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.

Saturday, August 29, 2015

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

Friday, February 28, 2014

Informatica 9.5.1 : infasetup node management

Command line program "infasetup" can be used for Domain and Node management.
Here are some of the commands.

  • BackupDomain
  • DefineDomain
  • DefineGatewayNode
  • DeleteDomain
  • RestoreDomain
  • UpdateGatewayNode