ETL Process (Extraction, Transformation, and Loading)

Extracting data from source systems and bringing it into the data warehouse is commonly called ETL (Extract-Transform-Load)

Methodlogy can be vary but the process remains same

Usually all the three phases execute in parallel since the data extraction takes time, so while the data is being pulled another transformation process executes, processing the already received data and prepares the data for loading and as soon as there is some data ready to be loaded into the target, the data loading kicks off without waiting for the completion of the previous phases.(Wiki, 2015)

References

http://docs.oracle.com/cd/B19306_01/server.102/b14223/ettover.htm

http://en.wikipedia.org/wiki/Extract,_transform,_load

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s