Join the Community

Sponsor

Free BI Digest

Need more help on this subject?

ETL Informatica

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

How to get Folders and Mapping names from Informatica Metadata Query

We can use OPB_MAPPING and OPB_SUBJECT tables residing under informatica Repository to obtain information about all the mappings under each Informatica Folder. Following SQL query shows you how to do it.

Read more: How to get Folders and Mapping names from Informatica Metadata Query

How to get Informatica Repository Information from Metadata

Some metadata views can be very handy to get Informatica Repository Information. Khow How.

Read more: How to get Informatica Repository Information from Metadata

Implementing Informatica Incremental Aggregation

Using incremental aggregation, we apply captured changes in the source data (CDC part) to aggregate calculations in a session. If the source changes incrementally and we can capture the changes, then we can configure the session to process those changes. This allows the Integration Service to update the target incrementally, rather than forcing it to delete previous loads data, process the entire source data and recalculate the same data each time you run the session.

Read more: Implementing Informatica Incremental Aggregation

Informatica Metadata Tables - Overview and Tutorial

Informatica PowerCentre stores all the information about mapping, session, transformation, workflow etc. in a set of database tables called metadata tables. While these tables are used internally by Informatica, one can get useful information by accessing it separately

Read more: Informatica Metadata Tables - Overview and Tutorial

Using Informatica Normalizer Transformation

Normalizer transformation is a native transformation in Informatica that can ease many complex data transformation requirements. Learn how to effectively use normalizer in this tutorial.

Read more: Using Informatica Normalizer Transformation

Informatica Join Vs Database Join

In this yet another "DWBI Concepts' Original article", we test the performance of Informatica PowerCentre 8.5 Joiner transformation versus Oracle 10g database join. This article gives a crucial insight to application developer in order to take informed decision regarding performance tuning.

Read more: Informatica Join Vs Database Join

Informatica Dynamic Lookup Cache

A LookUp cache does not change its data once built. But what if the underlying table upon which lookup was done changes the data after the lookup cache is created? Is there a way so that the cache always remain up-to-date even if the underlying table changes?

Read more: Informatica Dynamic Lookup Cache

Comparing Performance of SORT operation (Order By) in Informatica and Oracle

In this "DWBI Concepts' Original article", we put Oracle database and Informatica PowerCentre to lock horns to prove which one of them handles data SORTing operation faster. This article gives a crucial insight to application developer in order to take informed decision regarding performance tuning.

Read more: Comparing Performance of SORT operation (Order By) in Informatica and Oracle

Pushdown Optimization In Informatica

Pushdown Optimization which is a new concept in Informatica PowerCentre, allows developers to balance data transformation load among servers. This article describes pushdown techniques.

Read more: Pushdown Optimization In Informatica

Informatica Reject File - How to Identify rejection reason

When we run a session, the integration service may create a reject file for each target instance in the mapping to store the target reject record. With the help of the Session Log and Reject File we can identify the cause of data rejection in the session.

Read more: Informatica Reject File - How to Identify rejection reason