Many Informatica PowerCenter developers tend to use  SQL  Override during mapping development. Developers finds it easy and more productiv...

Surrogate Key is sequentially generated unique number attached with each and every record in a Dimension table in any Data Warehouse. We...

When your data warehouse is sourcing data from multi-time zoned data sources, it is  recommended to capture a universal standard time, a...

Quite often we deal with ETL logic, which is very dynamic in nature. Such as a discount calculation which changes every month or a specia...

Debugger is a great tool to troubleshoot your mapping logic, but there are instances where we need to go for a different troubleshooting ...

Debugger is an integral part of Informatica PowerCenter mapping designer , which help you in troubleshooting the ETL logical error or dat...

Informatica PowerCenter session partition can be used to process data in parallel and achieve faster data delivery. Using Dynamic Sessi...

Informatica Pushdown Optimization Option increases performance by providing the flexibility to push transformation processing to the mos...

Informatica PowerCenter Session Partitioning can be effectively used for parallel data processing and achieve faster data delivery. Para...

In addition to a better ETL design , it is obvious to have a session optimized with no bottlenecks to get the best session performance . A...

Restartable ETL jobs are very crucial to job failure recovery, supportability and  data quality  of any ETL system. In one of our prior ...

Processing fixed width file in Informatica PowerCenter is not a big deal. But this can be bit tricky if the fixed file contins both mult...

Lookup transformation is synonymous to SQL outer join, which is primarily used for relational and flat file data source lookups. But with...

Reusability is a great feature in Informatica PowerCenter which can be used by developers. Its general purpose is to reduce unnecessary c...

Informatica PowerCenter mapping variable can be effectively used to implement change data capture logic. The mapping variable is stored...

In one of our prior articles we described the  SCD Type 6  dimensional modeling technique. This technique is the combination of SCD Type1...

Restartable ETL jobs are very crucial to job failure recovery, supportability and data quality of any ETL System.  So you need to build ...

Most of the time when we process flat files in Informatica PowerCenter, we do some kind of file pre or post processing, such as unzip t...

Unlike SCD Type 2 , Slowly Changing Dimension Type 1 do not preserve any history versions of data. This methodology overwrites old data ...

Constraint based loading technique is available in  Informatica PowerCenter since couple of its prior versions. This PowerCenter feature ...