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 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

Business Intelligence Data Warehousing

Oracle Disable Indexes and Constraints During Insert

If you are attempting to insert millions of rows into an oracle database, you may want to temporarily disable indexes and constraints to improve the speed of the load. Here are 5 steps to follow that will disable constraints and make indexes unusable. You need to substitute the OWNER and TABLE on line 5 and …

Continue reading Oracle Disable Indexes and Constraints During Insert