3/15/2024 0 Comments Extract transformation load![]() ![]() Loading the data set batch-wise and periodically if it is too large. The ETL system should store the date and time the data was last extracted. Regularly loading only the updated data between the source and target systems. It involves extracting and transforming the data set from the data source to the data warehouse. This loading typically happens during the initial load. The following are methods for data loading: This process is well-defined, continuous and automated, and usually the loading happens batch-wise. Once the data extraction and processing steps are complete, the final process is loading the transformed data into the data warehouse from the staging area. (See how data normalization relates to the Transform step.) Step 3.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |