We spoke about different etl frameworks in our prior articles. Here in this article lets talk about an ETL framework to deal with parame...

Incremental Aggregation is the perfect performance improvement technique to implement; when you have to do aggregate calculations on your...

Data quality is very critical to the success of every data warehouse projects. So ETL Architects and Data Architects spent a lot of time ...

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

A high-level systematic ETL design will help to build efficient and flexible ETL processes. So special care should be given in the desig...

In the typical case for a data warehouse, dimensions are processed first and the facts are loaded later, with the assumption that all req...

In our couple of prior  articles we spoke about change data capture , different techniques to capture change data and a  change data capt...

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

Surrogate keys are widely used and accepted design standard in data warehouses. It is sequentially generated unique number attached with ...

Informatica has developed a solution that leverages the power of grid computing for greater data integration scalability and performance ...

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...

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

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...

SCD Type 2 , is design to generate new records for every change of a dimension attribute, so that complete historical changes can be trac...

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

In a matured data warehouse environment, it is very common to see fact tables with dozens of dimension tables linked to it. If we are usin...

In couple of our previous articles, we discussed how to design and implement SCD Type1 , Type 2 and Type 3 . We always can not fulfill al...

A surrogate key is an artificial key that is used as a substitute for a natural key. Every surrogate key points to a dimension record , w...