• 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

Informatica Source, Target Command Makes File Processing Easier than Before

Source, Target Command Makes File Processing Easier than Beforen
Most of the time when we process flat files in Informatica PowerCenter, we do some kind of file pre or post processing, such as unzip the source file, create a custom header or footer for the target file etc. Such processing is normally done using Unix or Windows scripts, which is called using pre or post  session script. Now Informatica PowerCenter has provided Source, Target Commands to make such processing easy than before.
Continue Reading

Working with Router Transformation and Aggregator Transformation

Working with Aggregator and Souter Transformation
This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from multiple data sources and use Aggregator and Router Transformation. Router transformation can be used to split the data into different groups. And aggregator can be used to summarize data.
Continue Reading

Working with Aggregator and Sorter Transformation

Working with Aggregator and Souter Transformation
This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from multiple data sources and use Aggregator and Sorter Transformation. Using a sorter transformation, you can sort data either in an ascending or descending order. And aggregator can be used to summarize data. 
Continue Reading

SCD Type 1 Implementation using Informatica PowerCenter

SCD Type 1 Implementation using Informatica PowerCenter
Unlike SCD Type 2, Slowly Changing Dimension Type 1 do not preserve any history versions of data. This methodology overwrites old data with new data, and therefore stores only the most current information. In this article lets discuss the step by step implementation of SCD Type 1 using Informatica PowerCenter.
Continue Reading

Informatica PowerCenter Repository Contents Upgrade

Informatica PowerCenter Repository Upgrade
After an existing Informatica PowerCenter server binaries are upgraded to a higher version, we will have to upgrade the existing repository contents before we can enable the repository service and access the repository objects such as mappings, sessions, workflows etc... from the client tools. This article illustrates the step by step instructions for the upgrading the Informatica PowerCenter repository contents.
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