-
Conceptual question about "ETL"
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|