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

Informatica Performance Tuning Guide, Performance Enhancements - Part 4

Informatica Performance Tuning Guide, Performance Enhancements - Part 4

In our performance turning article series, so far we covered about the performance turning basics, identification of bottlenecks and resolving different bottlenecks. In this article we will cover different performance enhancement features available in Informatica PowerCener. In addition to the features provided by PowerCenter, we will go over the designs tips and tricks for ETL load performance improvement.

Continue Reading

Informatica PowerCenter Load Balancing for Workload Distribution on Grid

Informatica PowerCenter Load Balancing for Workload Distribution on Grid

Informatica PowerCenter Workflows runs on grid, distributes workflow tasks across nodes in the grid. It also distributes Session, Command, and predefined Event-Wait tasks within workflows across the nodes in a grid. PowerCenter uses load balancer to distribute workflows and session tasks to different nodes. This article describes, how to use load balancer to setup high workflow priorities and how to allocate resources.

Continue Reading

Informatica PowerCenter on Grid for Greater Performance and Scalability

Informatica PowerCenter on Grid for Greater Performance and Scalability

Informatica has developed a solution that leverages the power of grid computing for greater data integration scalability and performance. The grid option delivers the load balancing, dynamic partitioning, parallel processing and high availability to ensure optimal scalability, performance and reliability. In this article lets discuss how to setup Infrmatica Workflow to run on grid. 

Continue Reading

Informatica Performance Tuning Guide, Resolve Performance Bottlenecks - Part 3

Informatica Performance Tuning Guide, Resolve Performance Bottlenecks - Part 3

In our previous article in the performance tuning series, we covered different approaches to identify performance bottlenecks. In this article we will cover the methods to resolve different performance bottlenecks. We will talk about session memory, cache memory, source, target and mapping performance turning techniques in detail.

Continue Reading