Skip to main content

Points to keep in mind after upgradation of Informatica powerCenter new version



After upgrading Informatica PowerCenter, the INFA_HOME operating system environment variables must be set to a new PowerCenter installation path:
For example, when upgrading from 9.0 to 9.0.1, the path:
INFA_HOME=/opt/Informatica/9.0    is changed to path    INFA_HOME=/opt/Informatica/9.0.1

Other PowerCenter environment variables are relative to the INFA_HOME environment variable. Therefore, one need not apply any further changes, but it is worthwhile to check if the above statement is true.

An example setting for other PowerCenter environment variables is presented below:
INFA_HOME=/opt/Informatica/9.0.1
INFA_DOMAINS_FILE=$INFA_HOME/domains.infa
PM_ROOT=$INFA_HOME/server/infa_shared
PM_HOME=$PM_ROOT
PATH=$PATH:$INFA_HOME/server/bin
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFA_HOME:$INFA_HOME/server/bin
JRE_HOME=$INFA_HOME/Java

For each Integration Service make sure that $PMRootDir variable is set properly. Is should be set to path:
/server/infa_shared
Where is PowerCenter installation directory, defined by INFA_HOME environment variable.

Comments

Post a Comment

Popular posts from this blog

Data virtualization

Data virtualization is a process of offering a data access interface that hides the technical aspects of stored data, such as location, storage structure, API, access language, and storage technology. Analogous to concept of views in databases Data virtualization tools come with capabilities of  data integration, data federation, and data modeling Requires more memory caching Can integrate several data marts or data warehouses through a  single data virtualization layer This concept and software is a subset of data integration and is commonly used within business intelligence, service-oriented architecture data services, cloud computing, enterprise search, and master data management. Composite, Denodo, and Informatica are the largest players in the area of data virtualization References for definition: http://www.b-eye-network.com/view/14815
7 comments
Read more

Difference between server jobs and parallel jobs in Datastage

Server job stages do not have in built partitioning and parallelism mechanism for extracting and loading data between different stages. To enhance the speed and performance in server jobs is to     - Enable inter process row buffering through the administrator. This helps stages  to exchange data as soon as it is available in the link.     - Using IPC stage also helps one passive stage read data from another as soon as data is available. In other words, stages do not have to wait for the entire set of records to be read first and then transferred to the next stage.    - Link partitioner and link collector stages can be used to achieve a certain degree of partitioning paralellism. All of the above features which have to be explored in server jobs are built in datastage Parallel jobs . The Px engine runs on a multiprocessor sytem and takes full advantage of the processing nodes defined in the configuration file. Both SMP and MMP archi...
1 comment
Read more

Find Changed Data by computing Checksum using MD5 function in Informatica

Introduction: Capturing and preserving the state of data across time is one of the core functions of a data warehouse, but CDC can be utilized in any database or data integration tool. There are many methodologies such as Timestamp, Versioning, Status indicators, Triggers and Transaction logs exists but MD5 function outlines on working with Checksum. Overview: MD5 stands for Message Digest 5 algorithm.It calculates the checksum of the input value using a cryptographic Message-Digest algorithm 5 and returns a128-bit 32 character string of hexadecimal digits (0 - F). Advantage of using MD5 function is that, it will reduce overall ETL run time and also reduces cache memory usage by caching only required fields which are utmost necessary. Implementation Steps : Identify the ports from the source which are subjected to change. Concatenate all the ports and pass them as parameter to MD5 function in   expression transformation Map the MD5 function output to a checksum outp...
1 comment
Read more