Sequence Generator Transformation for Unique Key Generation

Johnson Cyriac Feb 28, 2013
|
Sequence Generator Transformation for Unique Key Generation
The Sequence Generator transformation generates numeric values in a sequential order. Use the Sequence Generator to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers. In this tutorial lets see a practical implementation of Sequence Generator transformation.

5 Restartability Design Pattern for Different Type ETL Loads

Johnson Cyriac Feb 19, 2013
|
ETL Restartability design for informatica workflows
Restartable ETL jobs are very crucial to job failure recovery, supportability and data quality of any ETL System.  So you need to build your ETL system around the ability to recover from abnormal ending of a job and restart. So a well designed ETL system should have a good restartable mechanism. In this article lets discuss  ETL restartability approaches to support different type of ETL Jobs such as Dimension loads, Fact Loads etc...

Informatica Source, Target Command Makes File Processing Easier than Before

Johnson Cyriac Feb 14, 2013
|
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.

Working with Router Transformation and Aggregator Transformation

Johnson Cyriac Feb 10, 2013
|
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.

Working with Aggregator and Sorter Transformation

Johnson Cyriac Feb 5, 2013
|
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. 



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.