Recent Pmcmd Posts from Tech Monger

PMCMD PingService Examples - Informatica Integration Service

2018-10-24T17:36:10.751604Z

If you have informatica domain running then it is important to have an uptime monitoring mechanism for the services running under that domain. Integration service is one of the most utilized service for ETL. So it is important to configure an alert if integration service goes down. In this tutorial we will make use of PMCMD pingservice command to check status of an integration service with example.

GetSessionStatistics - Informatica Session Statistics using PMCMD

2018-06-12T18:04:59.069442Z

In this tutorial we will learn how to use pmcmd getsessionstatistics command to fetch essential session run information. This tool is handy especially if you want to automate report containing session run summary. In output you would get vital details about session and transformations like Failed and Success Rows of Source & Target, Transformation statistics like Applied, Affected and Rejected rows, Throughput Per Second. Additionally it also outputs an error code along with error details of both individual transformations and session.

Secure Informatica Scripts with PMCMD and PMREP

2018-04-18T09:40:13.778165Z

Often you require details about informatica objects from repository database. Informatica setup provides an API to fetch required details without querying actual repository database. This API comes under two wrapper scripts known as PMCMD and PMREP. To use this API in script you would need to provide repository password which makes code insecure; Especially connecting with Administrator User. However to hide passwords in scripts this API also facilitates an option to provide password in encrypted format. Below we will discuss how you can use encrypted password with PMCMD and PMREP to make your programs more secure.