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

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

Informatica 9.5.1 : Monitor Integration Service ( pingservice )

Pingservice pmcmd command can be used to pro-actively monitor Informatica Integration service.

Syntax : pmcmd PingService <<-service|-sv> service [<-domain|-d> domain] [<-timeout|-t> timeout]

Example

pmcmd pingservice -sv IS_INFA_PROD -d DOM_INFA_PROD