An ETL Parameter Framework to Deal with all sorts of Parametrization Needs

An ETL Parameter Framework to Deal with all sorts of Parametrization Needs

We spoke about different etl frameworks in our prior articles. Here in this article lets talk about an ETL framework to deal with parameters we normally use in different ETL jobs and different use cases. Using parametrization in the ETL code increases code reusability, code maintainability and is critical to the quality of the code and reduces the development cycle time.

Continue Reading

Dynamic Transformation Port Linking Rules in Infromatica Cloud Designer

Dynamic Transformation Port Linking Rules in Infromatica Cloud Designer

One of the coolest features which was missing in Informatica PowerCenter was the capability to dynamically link ports between transformations. Many other ETL tools has already been providing this features in there tools. With Informatica Cloud Designer, you can build mapping, with dynamic rules to connect ports between transformations.

Continue Reading

Informatica Cloud Mapping Tutorial for Beginners, Building the First Mapping

Informatica Cloud Mapping Tutorial for Beginners, Building the First Mapping

In the last couple of articles we discussed the basics of Informatica Cloud and Informatica Cloud Designer. In this tutorial we describe how to create a basic mapping, save and validate the mapping, and create a mapping configuration task. The demo mapping reads and writes data sources, also include the parameterization technique.

Continue Reading

Informatica Incremental Aggregation Implementation and Business Use Cases

Informatica Incremental Aggregation Implementation and Business Use Cases

Incremental Aggregation is the perfect performance improvement technique to implement; when you have to do aggregate calculations on your incrementally changing source data. Rather than forcing the session to process the entire source data and recalculate the same data each time you run the session, incremental aggregation persist the aggregated value and adds the incremental changes to it. Lets see more details in this article.

Continue Reading

Informatica Cloud Designer for Advanced Data Integration On the Cloud

Informatica Cloud Designer for Advanced Data Integration On the Cloud

Informatica Cloud is an on-demand subscription service that provides cloud applications. It uses functionality from Informatica PowerCenter to provide easy to use, web-based applications. Cloud Designer is one of the applications provided by Informatica Cloud. Lets see the features of Informatica Cloud Designer in this article.

Continue Reading