An ETL Parameter Framework to Deal with all sorts of Parametrization Needs

An ETL Parameter Framework to Deal with all sorts of Parametrization Needs

We spoke about different etl frameworks in our prior articles. Here in this article lets talk about an ETL framework to deal with parameters we normally use in different ETL jobs and different use cases. Using parametrization in the ETL code increases code reusability, code maintainability and is critical to the quality of the code and reduces the development cycle time.

Continue Reading

Informatica Incremental Aggregation Implementation and Business Use Cases

Informatica Incremental Aggregation Implementation and Business Use Cases

Incremental Aggregation is the perfect performance improvement technique to implement; when you have to do aggregate calculations on your incrementally changing source data. Rather than forcing the session to process the entire source data and recalculate the same data each time you run the session, incremental aggregation persist the aggregated value and adds the incremental changes to it. Lets see more details in this article.

Continue Reading

How to Use Error Handling Options and Techniques in Informatica PowerCenter

How to Use Error Handling Options and Techniques in Informatica PowerCenter

Data quality is very critical to the success of every data warehouse projects. So ETL Architects and Data Architects spent a lot of time defining the error handling approach. Informatica PowerCenter is given with a set of options to take care of the error handling in your ETL Jobs. In this article, lets see how do we leverage the PowerCenter options to handle your exceptions.

Continue Reading

How to Avoid The Usage of SQL Overrides in Informatica PowerCenter Mappings

How to Avoid The Usage of SQL Overrides in Informatica PowerCenter Mappings

Many Informatica PowerCenter developers tend to use SQL Override during mapping development. Developers finds it easy and more productive to use SQL Override. At the same time ETL Architects do not like SQL Overrides as it hide the ETL logic from metadata manager. In this article lets see the options available to avoid SQL Override in different transformations.

Continue Reading

Informatica PowerCenter Design Best Practices and Guidelines

Informatica PowerCenter Design Best Practices and Guidelines

A high-level systematic ETL design will help to build efficient and flexible ETL processes. So special care should be given in the design phase of your project. In following we will be covering the key points one should keep in mind while designing an ETL process. The following recommendations can be integrated into your ETL design and development processes to simplify the effort and improve the overall quality of the finished product.

Continue Reading