Informatica

How To Learn Informatica

A question that I often receive is: "What should I do to learn how to develop ETL mappings using Informatica PowerCenter?" Here are the steps that I would take to learn how to do extract, transform, and load with Informatica PowerCenter. I assume that you already have knowledge of SQL. If you don't know SQL …

Continue reading How To Learn Informatica

Informatica

Informatica Mapping Insert Update Delete

There are situations where you need to keep a source and target in sync.  One method to do this is to truncate and reload.  However this method is not that efficient for a table with millions of rows of data.  You really only want to: insert rows from the source that don't exist in the …

Continue reading Informatica Mapping Insert Update Delete