"Robert" <callingrw (AT) yahoo (DOT) com> wrote:

What is it?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

On 19.01.2007 02:49, Gene Wirchenko wrote:
http://www.acronymfinder.com/af-quer...=etl&Find=Find

robert

Robert Klemme <shortcutter (AT) googlemail (DOT) com> wrote:

That site has over 100 expansions for ETL. Which one do you
mean?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

Am Thu, 18 Jan 2007 17:49:24 -0800 schrieb Gene Wirchenko:

Extraction, Transformation, Load. In data warehouses, you collect
(*extract*) data from different sources (flat files, production
databases, spreadsheets) with independent, hence different data
representations (so the sex of a person can be m/f in one system , 0/1
in another; system X gives you litres, system X gallons; system A has
percent full, system B has percent free), which have to be
*transformed* to a consolidated form so they can be *loaded* into the
data warehouse.

Many use Perl as a language to do those transformations (as it is
particularly good at finding patterns and transforming strings); there
are also a lot of tools around that let you set the ETL rules using a
GUI.

Joachim