Buy Smart ETL Tool virtual university final fall 2015 projectView more random threads:
- Multipurpose Viva Exam System (Mobile & Web) spring 2012...
- Online Restaurant Coupon Deals php and mysql project spring...
- FORMAT OF THE INTERNSHIP REPORT for Vu Students
- The date is extended for the second phase assignment of the...
- All projects date is extended for SRS Spring 2012
- Vu Final Term project SEO Link Engine Fall 2011
- vu final year project for sale Real-Time Financial Data...
- cs619 viva instructions for spring 2012 viva in march 2013
- result of cs619 vu final year project fall 2012
- vu final project phase 3 which is called iteration 1 and...
“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.
Prerequisites:
Students should have good concepts of databases (CS403) and Data Warehouse (CS614)
Requirements:
1. The user will first select the database/databases and DWH for mapping.
2. The software will show the summery to the user regarding the structure and metadata of the databases as well as of the DWH.
3. The software will provide the facility to the user to map the different tables and columns of database (s) to the tables and columns of DWH.
4. The software should provide the facility to extract the data from multiple databases.
4.1. Extraction can be of the following types.
4.1.1. Full Extraction
4.1.2. Incremental Extraction
5. The software should provide the facility to transform the data.
5.1. The user can select any type of transformation from the following (one or more)
5.1.1. Splitting/Joining
5.1.2. Conversion
5.1.3. Summarization
5.1.4. Enrichment
6. The software should provide the facility to load the data in to DWH.
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
Sponsored Links
Urgent call: 03455242488. | Virtual University Assignments
Virtual University GDBs | Virtual University Papers | Vu Projects | Vu Handouts
About Expert
There are currently 1 users browsing this thread. (0 members and 1 guests)