August 23, 2017

What happens when the session/mapping is triggered?

November 8, 2016

PMCMD Commands In Informatica

Informatica provides multiple built-in command line programs or utilities to interact with its services and features. The best place to […]
November 4, 2016

Which ODBC driver need to be selected in order to use SQL Server 2014 source System?

November 1, 2016

How can we roll back a deployment group?

Here are the steps to roll back a deployment. You can roll back a deployment and purge the deployed versions […]
October 25, 2016

DataMart Vs Data Warehouse

Sam started his startup and over the years the startup has brown big and become an enterprise with multiple outlets […]
October 25, 2016

What is dimension table in data warehouse?

Dimension table contains the descriptive information about the numerical values in the fact table, i.e they contain the attributes of […]
October 25, 2016

What is fact table in data warehouse?

Fact table contains numerical values which can be measured. Hence these are also called as measures. Basically, these are nothing […]
October 25, 2016

What is a Data Warehouse?

Data Warehouse A data warehouse (DWH) is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured […]
July 21, 2016

Steps to change Password of Informatica Repository DB

Important points to note before this is done: Repository backup Please refer to the Optional and Required substitutions from the […]
July 18, 2016

What is the importance of Unix Scripting? In which scenarios do we use UNIX scripting as admin as well as developer.

***This question is raised by one of the students from my Informatica Administration course. CLICK HERE FOR THE COURSE DETAILS*** […]
July 7, 2016

PMREP Commands

To connect to the Repository: pmrep connect -r <REPOSITORY NAME> -d <DOMAIN NAME> -n <USER> -x <PASSWORD>  To get the […]
July 7, 2016

What is the difference between Worker node, Backup node, Primary node, Secondary node, Gateway node?

June 16, 2016

Upgrade Planner for Informatica 10.0

June 15, 2016
Informatica Power Center

New features/enhancements with Informatica 10.0

June 15, 2016

Multiple Repositories under a single Oracle Instance

June 15, 2016

General Suggestions for Optimizing the Power Center Enviornment

June 15, 2016

Basic Performance Tips for ETL/Informatica mappings – Part 2

June 15, 2016

Basic Performance Tips for ETL/Informatica mappings – Part 1