Virtual University of Pakistan Study forum !
“Smart ETL Tool”
It is a desktop application which enables the user to map multiple databases to a DWH in a DBMS. Extract, Transform and Load (ETL) is a process used in Data Warehouse. This process Extracts the data from multiple sources, Transforms the data for storing it in proper format/structure and then Load in to DWH.
Students should have good concepts of databases (CS403) and Data Warehouse (CS614)
4.1. Extraction can be of the following types.
4.1.1. Full Extraction
4.1.2. Incremental Extraction
5.1. The user can select any type of transformation from the following (one or more)
6.1. The user can select any type of loading from the following
6.1.1. Full data refresh
6.1.2. Incremental data refresh
6.1.3. Trickle/continuous feed
Tools: Java/net Framework And Sql server