ETL is abbreviation of extract, transform, and load.
ETL is software that enables businesses to consolidate their disparate data while moving it from place to place, and it doesn't really matter that that data is in different forms or formats.
The data can come from any source.
ETL is powerful enough to handle such data disparities.
First, the extract function reads data from a specified source database and extracts a desired subset of data.
Next, the transform function works with the acquired data - using rules orlookup tables, or creating combinations with other data - to convert it to the desired state.
Finally, the load function is used to write the resulting data to a target database.
No comments:
Post a Comment