Hi,

A simple question but I just want to clarify my understanding:

E = Extract
T = Transform
L = Load


I clearly understand the "E" part which simply means extracting data from the data sources e.g. your OLTP systems or whatever into your Data Mart/ Data Warehouse.

However I am now fully clear as to what do the "T" and the "L" really represent.

Does the "T" (Transform) represent the processing that we do in our Datamart/DW (which some also refer to as the 'Staging Area') or ???
Can you please help be conceptually be clear about this?

Does the "L" (Load) part represent the process of updating our dimensions and Cubes?

I'll appreciate your reply. Thanks