SCD Type 1 Implementation using Informatica PowerCenter

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

Informatica PowerCenter Repository Contents Upgrade

Johnson Cyriac Jan 25, 2013
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.

Informatica PowerCenter Constraint Based Load Ordering

Johnson Cyriac Jan 20, 2013
Informatica PowerCenter Constraint Based Loading
Constraint based loading technique is available in Informatica PowerCenter since couple of its prior versions. This PowerCenter feature will let you load multiple tables in a single session, which is having database level primary key - foreign key constraint or parent - child relation. In this article let's see what is needed to set up a session for constraint based loading.

Design approach to Update Huge Tables Using Oracle MERGE

Johnson Cyriac Jan 15, 2013
|
Design approach to Update Huge Tables in Informatica powercenter workflow
One of the issues 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.  We discussed about a design approach for this scenarion in one of our prior articles. Here in this updated article lets discuss a different approach to update Larger tables using Informatica Mapping.

Informatica PowerCenter Repository BackUp and Restore

Johnson Cyriac Jan 12, 2013
Change Data Capture Implementation Using CHECKSUM Number
Informatica PowerCenter administrators regularly backup the repository contents to prevent any data loose due to hardware or software problems. When the repository contents is backed up, it saves all the contents as a binary file which includes all the repository objects such as mapping, sessions, workflows etc. These binary files can be used to restore the contents if in case of any failure. In this article lets discuss the step by step process to backup and restore a PowerCenter Repository.

SCD Type 3 Implementation using Informatica PowerCenter

Johnson Cyriac Jan 6, 2013
|
SCD Type 3 Implementation using Informatica PowerCenter
Unlike SCD Type 2, Slowly Changing Dimension Type 3 preserves only few history versions of data, most of the time 'Current' and Previous' versions. The 'Previous' version value will be stored into the  additional columns with in the same dimension record.  In this article lets discuss the step by step implementation of SCD Type 3 using Informatica PowerCenter.



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.