ETL

This section contains a number of articles and tutorials on Informatica PowerCenter™ and PowerMart™ ETL tool.

Calling C executable from Java Transform

Details: Category: ETL Informatica; Published on Saturday, 18 February 2012 07:01; Written by Saurav Mitra; Hits: 37

There was a requirement to call a C++ executable binary from Informatica. The C++ program basically takes one input file name in the command line and calculates "value at risk" (VAR) values based on all the financial transaction records present in the given input file and outputs the final VAR value. This value along with other source data needs to be populated in the Target.

What is Active Lookup Transformation

Details: Category: ETL Informatica; Published on Friday, 17 February 2012 12:44; Written by Saurav Mitra; Hits: 75

Informatica 9x allows us to configure Lookup transformation to return multiple rows. So now we can retrieve multiple rows from a lookup table thus making Lookup transformation an Active transformation type.

Stop Hardcoding- Follow Parameterization Technique

Details: Category: ETL Informatica; Published on Saturday, 26 November 2011 05:39; Written by Saurav Mitra; Hits: 1191

This article tries to minimize hard-coding in ETL, thereby increasing flexibility, reusability, readabilty and avoides rework through the judicious use of Informatica Parameters and Variables.

Working with Informatica Flatfiles

Details: Category: ETL Informatica; Published on Sunday, 18 December 2011 12:06; Written by Saurav Mitra; Hits: 681

In this article series we will try to cover all the possible scenarios related to flatfiles in Informatica.

Informatica Excel Source

Details: Category: ETL Informatica; Published on Wednesday, 14 September 2011 01:29; Written by Navonil Sarkar; Hits: 1057

This article is a guide on how to Unload data from EXCEL file system to target relational database using Informatica.

CDC Implementation using Flatfile

Details: Category: ETL Informatica; Published on Wednesday, 30 November 2011 17:32; Written by Saurav Mitra; Hits: 868

This article shows how to use a flatfile to implement Change data Capture. Suppose we want to maintain the last extraction date in a flatfile, based on that value we want to capture the changed data of our business table.

Informatica Java Transformation

Details: Category: ETL Informatica; Published on Monday, 12 September 2011 22:31; Written by Saurav Mitra; Hits: 807

Feel the Power of Java programming language to transform data in PowerCenter Informatica. Java Transformation in Informatica can be used either in Active or Passive Mode.

CDC Implementation using Informatica Variable

Details: Category: ETL Informatica; Published on Saturday, 26 November 2011 12:30; Written by Saurav Mitra; Hits: 789

This article explains the Change Data Capture mechanism using Informatica Mapping Variable. We can use the Informatica Mapping Variable to extract the CDC data without using any other custom table. Here it goes.

APEAR - A tool for automating Informatica Performance Tuning

Details: Category: ETL Informatica; Published on Saturday, 27 August 2011 01:01; Written by Akash Mitra; Hits: 786

DWBIConcepts is launching APEAR – an Automated Performance Evaluation and Reporting tool for Informatica. As the name suggests, this tool will help you tune the performance of Informatica sessions fully automatically. Now don't waste your precious time any longer trying to figure out how to speed up your Informatica sessions.