To populate a data warehouse with up-to-date records extracted from
operational sources, exceptional tools are hired, called ETL tools,
which establish the footsteps of the entire business process as a
workflow. To provide a overall impression of the functionality of these
workflows reference to their most important feature, which comprise
• Identification of appropriate info at the source side
• Extraction of the data from large storage
• Transport of the data to the Data Staging Area
• Transformation, of the data approaching from various sources into a joint data format
• Cleansing of the resultant data set, on the basis of record and business rules Read More
• Identification of appropriate info at the source side
• Extraction of the data from large storage
• Transport of the data to the Data Staging Area
• Transformation, of the data approaching from various sources into a joint data format
• Cleansing of the resultant data set, on the basis of record and business rules Read More
No comments:
Post a Comment