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

ACTIVE LookUp, To Unlock the Limitations of JOINER Transformation

ACTIVE LookUp, To Unlock the Limitations of JOINER Transformation

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.

Continue Reading

Working with Flat File Source, LookUp & Filter Transformation

Working with Flat File Source, LookUp & Filter 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.
Continue Reading

11 Ways to Make Informatica PowerCenter Code Reusable

11 Ways to Make Informatica PowerCenter Code Reusable

Reusability is a great feature in Informatica PowerCenter which can be used by developers. Its general purpose is to reduce unnecessary coding which ultimately reduces development time and increases supportability. In this article lets see different options available in Informatica PowerCenter to make your code reusable.

Continue Reading

Working With Multiple Data Sources and Aggregator Transformation

Working With Multiple Data Sources and Aggregator Transformation

This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from multiple data sources and summarize the data using Aggregator Transformation.

Continue Reading