SOFT and HARD Deleted Records and Change Data Capture in Data Warehouse

SOFT and HARD Deleted Records and Change Data Capture in Data Warehouse

In our couple of prior  articles we spoke about change data capture, different techniques to capture change data and a change data capture frame work as well. In this article we will deep dive into different aspects for change data in Data Warehouse including soft and hard deletions in source systems.

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

Surrogate Key Generation Approaches Using Informatica PowerCenter

Surrogate Key Generation Approaches Using Informatica PowerCenter

Surrogate Key is sequentially generated unique number attached with each and every record in a Dimension table in any Data Warehouse. We discussed about Surrogate Key in in detail in our previous article. Here in this article we will concentrate on different approaches to generate Surrogate Key for different type ETL process.

Continue Reading

Surrogate Key in Data Warehouse, What, When and Why

Surrogate Key in Data Warehouse, What, When and Why

Surrogate keys are widely used and accepted design standard in data warehouses. It is sequentially generated unique number attached with each and every record in a Dimension table in any Data Warehouse. It join between the fact and dimension tables and is necessary to handle changes in dimension table attributes.

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