If you are picking up this topic out of order, I encourage you to go hop over to our first blog on it. You may get there quicker by following this link.
A collection of thoughts on software development (mostly)...
Showing posts with label ETL. Show all posts
Showing posts with label ETL. Show all posts
Aug 21, 2010
Automating ETL to do OLTP to OLTP - Part 2
Let's see where did we end up last time... Ah yes! We were talking about the "T" in the ETL process, otherwise known as "Transformation."
Automating ETL to do OLTP to OLTP - Part 1
ETL: Extraction, Transformation, and Loading
Traditionally, ETL refers to performing tasks to extract, transform and load data from an OLTP system to an OLAP system or environment. In this particular context, we are concerned with performing ETL tasks between a source OLTP system and a different destination OLTP system. This is the typical scenario when you are asked to convert data from an old system to a new one, where both source and target systems are main-line operational systems.
Traditionally, ETL refers to performing tasks to extract, transform and load data from an OLTP system to an OLAP system or environment. In this particular context, we are concerned with performing ETL tasks between a source OLTP system and a different destination OLTP system. This is the typical scenario when you are asked to convert data from an old system to a new one, where both source and target systems are main-line operational systems.
Subscribe to:
Posts (Atom)