Change Data Capture (CDC) Implementation Using CHECKSUM Number

Change Data Capture (CDC) Implementation Using CHECKSUM Number

Typically we use a date column or a flag column to identify the change record for change data capture implementation. But there can be scenarios where you source do not have any columns to identify the changed records, especially when working with legacy systems. Today in this article lets see how to implement Change Data Capture or CDC for such scenarios using checksum number.

Continue Reading

Data Cleansing and Standardization Using Regular Expression

Data Cleansing and Standardization Using Regular Expression

Data Quality is one of the major priorities of any data warehouse or any data integration project. We use different tools for data quality and data standardization implementation. But tools may not be the right solution for small projects which involve couple of data feeds. Regular Expression is an alternative approach for such small projects. In this article lets discuss about data quality implementation using Regular Expression or RegEx in Informatica PowerCenter.

Continue Reading

Informatica PowerCenter Designer Features for Improved Productivity

Informatica PowerCenter Designer Features for Improved Productivity

As a Informatica PowerCenter developer, you will be spending most of your development time with Mapping Designer than any other client tool. So it is really important to understand the features of the tool to improve your development productivity. Lets discuss couple of top productivity features of PowerCenter Mapping Designer.

Continue Reading

Change Your Target XML File Name Dynamically Without Any Scripts

Change Your Target XML File Name Dynamically Without Any Scripts

Just like creating flat files with dynamic file name, you might get requirements to generate XML output files with dynamic name. In this article lets see an easy method to generate XML output files with dynamically changing name.

Continue Reading

Working with Joiner Transformation and Rank Transformation

Working with Joiner Transformation and Rank Transformation

This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from Flat File data sources and uses Joiner Transformation and Rank Transformation to build a consolidated sales report.
Continue Reading