Change Your Target XML File Name Dynamically Without Any Scripts

Johnson Cyriac Nov 28, 2012
Change Your Target XML File Name Dynamically
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.

Working with Joiner Transformation and Rank Transformation

Johnson Cyriac Nov 23, 2012
|
character encoding in Informatica  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.

Processing UNICODE Characters in Informatica PowerCenter Workflow

Johnson Cyriac Nov 18, 2012
|
character encoding 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.

Concurrent Workflows to Reduce Warehouse ETL Load Time

Johnson Cyriac Nov 13, 2012
|
Informatica concurrent workflow
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.

ACTIVE LookUp, To Unlock the Limitations of JOINER Transformation

Johnson Cyriac Nov 8, 2012
|
Informatica user defined error handling
Joiner Transformation can be used to achieve the functionality of SQL join Operation including  full outer join. Additionally we can use Joiner to join data from heterogeneous data sources. But it is limited with the operators, which can be used in the join condition, it can use only 'equal to' operator in the join condition. In this article lets see how we can unlock this limitation using Informatica PowerCenter Active LookUp transformation.

Working with Flat File Source, LookUp & Filter Transformation

Johnson Cyriac Nov 5, 2012
|
Informatica LookUp Transformation
This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from Flat File  data sources and use LookUp and Filter Transformation.



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.