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

In our performance turning article series, so far we covered about the performance turning basics , identification of bottlenecks and r...

Informatica PowerCenter Workflows runs on grid , distributes workflow tasks across nodes in the grid . It also distributes Session, Comman...

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

In our previous article in the performance tuning series, we covered different approaches to identify performance bottlenecks. In this a...

In our previous article in the  performance tuning series, we covered the basics of Informatica performance tuning process and the sessio...

Performance tuning process identifies the bottlenecks and eliminate it to get a better acceptable ETL load time. Tuning starts with the...

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

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

One of the issues we come across during the ETL design is "Update Large Tables".  This is a very common ETL scenarion especial...

In large data integration projects, it is quite common to source data from multiple systems , sources, regions etc... As the number of d...

You might have come across an ETL scenario, where you need to update a huge table with few records and occasional inserts. The straight f...

Lookup is one of the frequently used transformations in Informatica PowerCenter. This transformation is considered to be relatively simpl...

One of the issue we come across during the ETL design is "Update Large Tables".  This is a very common ETL scenarion especiall...

Many times we create snapshot tables and do build reporting on top of it. Refreshing the underlying table became difficult, if the report...