Ans:
ETL stands for the Extraction, Transform and Loading,they are three database functions, they are combined into one tool to pull out data from one database and place it into another database.
Extract : The process of the reading the data from one database
Transform: The process of converting the extracted data from its previous form into the form it needs to be so that it can be placed into another database. Transformation occurs by using rules or by lookup tables or by combining data into another data.
Load: The process of writing the data to the target database.
ETL is used to migrate data from one database to another, to forms Data Marts and Data Ware House also to conver one database from one type to another.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment