Informatica Performance Tuning Guide, Performance Enhancements - Part 4

Johnson Cyriac Nov 30, 2013
|
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.

Surrogate Key Generation Approaches Using Informatica PowerCenter

Johnson Cyriac Nov 21, 2013
|
Different Approaches to Generate Surrogate Key in 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.

Surrogate Key in Data Warehouse, What, When and Why

Johnson Cyriac Nov 13, 2013
|
Surrogate Key in Data Warehouse, What, When, Why and Why Not
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.

Informatica PowerCenter Load Balancing for Workload Distribution on Grid

Johnson Cyriac Nov 8, 2013
|
Informatica PowerCenter load balancing
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.



About US Contact US Advertise Guest Post Terms and Conditions Privacy Policy Disclaimer

© 2012-2013 Data Intelligence Solution, All Rights Reserved
The contents in this site is copyrighted to Data intelligence Solution and may not be reproduced on other websites.