May 3, 2017
Update Strategy Transformation

How should the target table be updated if there is no primary and unique key defined?

March 2, 2017
Sequence Generator Transformation

Possible cases of reverting the Sequence numbers of the Sequence Generator Transformation

February 20, 2017
Sequence Generator Transformation

How sequence can be used to assign missing values in a table?

February 20, 2017
Expression Transformation

Can Expression be used as Sequence transformation, if yes how?

January 27, 2017

If update override option is already in tgt instance why do we need upd strategy?

Update Strategy works only when you have primary key defined in the target table/ definition and when you want to […]
January 23, 2017

What is the difference between shortcut and reusable transformation?

A shortcut is a reference (link) to an object in a shared folder with in a repository, these are commonly […]
January 5, 2017

Concatenation of two active transformation

The Problem: You cannot connect multiple active transformations or an active and passive transformation to the downstream transformation or transformation […]
December 22, 2016

Informatica – Difference between Connected Lookup & Unconnected Lookup

December 22, 2016

All about SHORTCUTS in Informatica

There is always a main destination/target even if we use any shortcuts. In real world, using shortcuts to get something […]
December 22, 2016
Transformations in Informatica

Brief about Informatica’s Transformations

Transformations help us to transform the source data according to the requirements of target system to¬†ensure the quality of the […]
December 22, 2016

All you need to know about folders in Infromatica

Folders in Informatica Just like we create folders and organize content in our personal lives and work either physically or […]
December 22, 2016

What is Check In and Check Out in Informatica?

In Informaitca, from version 8x, we use Check in and Check out operations for versioning. Whenever there is a need […]
December 22, 2016

Types of Lookup Caches in Informatica

There is always quite some confusion on the different types of caches available for Lookup Transformation and which one to […]
December 22, 2016
Informatica Debugger

How to use Informatica debugger?

Informatica Debugger is to view the data changes or how the data changes through the logic implemented in a mapping. […]
December 22, 2016

Informatica Transformations in 5 minutes

December 20, 2016

Use of the property FORWARDING REJECTED ROWS in an Update Strategy transformation??

June 15, 2016

Basic Performance Tips for ETL/Informatica mappings – Part 1

January 9, 2016

Reconciliation using Informatica

Reconciliation is a process to insure the data integrity. Informatica Power Center can be used for reconciliation process at data […]