• design
  • performance
  • data quality
  • blog

Popular Posts

  • Informatica PowerCenter 9 Installation and Configuration Complete Guide
  • SCD Type 2 Implementation using Informatica PowerCenter
  • Informatica Performance Tuning Guide, Tuning and Bottleneck Overview - Part 1
  • Implementing Informatica PowerCenter Session Partitioning Algorithms
  • Informatica Performance Tuning Guide, Identify Performance Bottlenecks - Part 2

Random Posts

Posts Being Viewed

Understand Informatica PowerCenter Source Analyzer

Informatica  PowerCenter Source Analyzer
In one of our previous article, we got to know the different client components of Informatica PowerCenter.  Source Analyzer - The first tool in PowerCenter Designer,  is used to identify the sources that will be used to build the data mart or warehouse and create definitions for those sources. Source definitions describe the sources that are going to be providing data to the warehouse. There are different ways to create source definitions.
Continue Reading

Informatica PowerCenter Client Tools Overview

Informatica PowerCenter Client Tools
The PowerCenter Client consists of applications that developers use to design mappings, mapplets, create sessions and workflows to load the data, and monitor workflow progress. In this article, lets discuss about the following applications and tools, which is used by developers during the development process.
Continue Reading

ETL Design approach to Update Huge Tables

Design approach to Update Huge Tables in Informatica powercenter workflow
One of the issue we come across during the ETL design is "Update Large Tables".  This is a very common ETL scenarion especially when you treat with large volume of data like loading an SCD Type 2 dimension table.  Here in this article lets discuss an approach to update Larger tables using Informatica Mapping.
Continue Reading

Design Approach to Ensure High Data Availability During Data Refresh

Design approach to ensure high data availability during data refresh
Many times we create snapshot tables and do build reporting on top of it. Refreshing the underlying table became difficult, if the report needs to be available 24x7 with out any down time. The refresh process can be a major design bottleneck, if in case the refresh takes hours. In this article lets discuss a design approach to make the target table data highly available.
Continue Reading

Error Handling Made Easy Using Informatica Row Error Logging

Error Handling made easy in Informatica powercenter workflow
Every time we start with a Data Warehouse or Data Integration project we spent lot of time defining our error handling approach. Still there are good chances that we might miss some scenarios because of unexpected data issues. Here in this article, lets us discuss an approach to handle the unexpected error.
Continue Reading

Processing high precision numbers in Informatica PowerCenter

High Precision Number
Quite often we process very large numbers in our mapping, like Credit Card Numbers, Bank Account Number or even some scientific numbers which needs high precision. Informatica PowerCenter can process numbers up to 15 digit precision without having high precision configuration. We can't treat bigger numbers more than 15 digits as normal numbers, treating so will lead to truncation or rounding of the numbers. In this tutorial we will see how we can process high precision numbers in Informatica PowerCenter and general guidelines for using high precision configuration.
Continue Reading
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
About US Contact US Advertise Guest Post Terms and Conditions Privacy Policy Disclaimer
© 2012-2017 Data Integration Solution, All Rights Reserved
The contents in this site is copyrighted to Data Integration Solution and may not be reproduced on other websites.
Designed By: Blogger Templates | Templatelib