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

Processing UNICODE Characters in Informatica PowerCenter Workflow

Processing UNICODE Characters in Informatica PowerCenter Workflow

Couple of days back one of my friends mailed me and said, he is not able to process Arabic characters using Informatica PowerCenter workflow. You might have faced same issue in processing scripts such as Arabic, Hebrew, Chinese etc. Let discuss about how we can process such non English scripts in Informatica PowerCenter workflows.

Continue Reading

Concurrent Workflows to Reduce Warehouse ETL Load Time

Concurrent Workflows to Reduce Warehouse ETL Load Time

In large data integration projects, it is quite common to source data from multiple systems, sources, regions etc... As the number of data sources increases, the ETL load time also increases, because of the increasing data volume. One way to reduce the load time is by running different ETL process in parallel. Informatica PowerCenter's capability to run workflow concurrently can be used in such scenarios to reduce the ETL load time.

Continue Reading