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

Informatica Powercenter Repository Backup - Sample Shell Script

Sample Script for Repository Backup on daily basis

#!/bin/bash
############## Initialization ###########################
LOG=/home/infa/Scripts/logs/infa_rep_backup.log
BACKUP_DAY=`date +"%a"` ## Mon Tue Wed Thu Fri Sat Sun
BACKUP_FILE=$PMRootDir/Backups/rep_infa_qa_backup_$BACKUP_DAY.rep

Informatica Powercenter Repository Backup

Step 1

Log onto the Admin Console.

Step 2

Select Repository service from Domain Navigator.

 

.
Step 3

Click on Actions >> Repository Contents >> Back Up.

Step 4

Enter User credentials and Backup file name.
Click OK.

Step 5

Back up complete.

Informatica Powercenter 9.5.1 - Create and Apply Labels

Step 1

Login to Repository Manager.
Select "Versioning >> Labels ".

 

Step 2

Create new label using Label Editor.
Enter appropriate Label Name and Click OK to create the label.

Step 3

To Apply labels - Select "Versioning >> Apply Label".

 

Step 4

 Apply Label wizard will popup. Click next.

Step 5

 Add objects to be labeled. Click next.

Step 6

 Open Label browser and select appropriate label.

Step 7

Select "Label all children"/"Label all parents" options if required.
Click Apply.

Step 7

Label applied to the selected objects.

Informatica Powercenter 9.5.1 Express Edition Install for Windows

Step 1

Download Powercenter express Personal edition ( free download ) from https://community.informatica.com/solutions/pcexpress

Step 2

Extract zip file PowerCenter_Express_Server_Client_Installer_winem-64t.zip.
Click on install.bat

Step 3

Installation wizard will pop up. Accept terms of the license agreement.
Click Next.

Step 4

Select installation directory and license file location. Click Next.

Step 5

Review pre installation summary. Click Next.

Step 6

Installation in progress.

Step 7

Configuration in progress.

Step 8

Setup Administrator credentials and click next.

Step 9

Defining the domain.

Step 10

Installation complete.