powercenter

Listening to a Database change with Informatica PowerCenter

Although it is common practice to use the Informatica PowerCenter Event-Wait task to listen for a particular file being ready to be processed and to start the worklet/session, in the scenario presented, what causes the process to start is a change in the database. The following example shows the approach taken to start the extraction process in PowerCenter.

Blog

PowerCenter: TM_6190 – Why It Happens And How To Solve It

This problem tends to appear in advanced stages of development, when we try to fix connections in lookups or procedures that we realized as being wrong.

Blog

Informatica PowerCenter as an ETL tool

In its essence, Informatica PowerCenter is a software whose main function is to extract data from different systems, data cleaning and transformation according to business rules, and then be loaded in a data mart or a data warehouse.

Blog

Using Powercenter to load data from files using a control table

The purpose of this tutorial is to provide a possible solution to automate the procedure as much as possible using Powercenter and Oracle/PLSQL.