0092 3125718857
WhatsApp for More Details
Smart ETL Tool Design Phase
Get Smart ETL Tool Design Phase at very low cost. Also get complete trialing providing by IT experts. Following is the sample design phase.
Smart ETL Tool
Design Document
Version 1.0
Group Id: <Mention your group id>
Supervisor Name :< >
Revision History
Date (dd/mm/yyyy) | Version | Description | Author |
Current date
|
Introduction of the project
|
||
Table of Contents
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 andthen Load in to DWH.
Requirements:
3.1 Add Executive
Admin
Add ()
Save ()
Process ()
Response
Updated
3.2 Remove Executive
Admin
Remove ()
Check ()
Process ()
Response
Updated
3.3 Load Data:
Admin
Load ()
Save ()
Process ()
Response
Updated
3.4 Transform Data
Admin
Transform ()
Check ()
Process ()
Response
Transformed
3.5 Extract Data
Admin
Extract ()
Check ()
Process ()
Response
Extracted
Executive
Generate ()
Contents()
Process ()
Response
Save
Star schema is provided.
Add data:
Extract Data:
Report:
Test Case Title: Add Database
Preconditions | Admin will be able to add data in database from different sources. |
Actions |
Click add data Enter Db details Press connect System will check the details After connecting create new database Create new table Enter the data for the table Press Go
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested |
Test Case Title: Extract Data
Preconditions | Admin will be able to extract data in database from different sources. |
Actions |
Click add data Enter Db details Press connect Smart ETL Tool Design Phase System will check the details After connecting create new database Click import data Select db file Press Go
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested |
Test Case Title: Transform Data
Preconditions | Admin will be able to transform data in database from different sources. |
Actions |
Click add data Enter Db details Press connect System will check the details After connecting create new database Click import/export data Select db file Press Go
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested |
Test Case Title: Add executive
Preconditions | Admin will be able to add an executive account on the application. |
Actions |
Click create new account Smart ETL Tool Design Phase Add details Add account role Hit enter
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested |
Test Case Title: Remove executive
Preconditions | Admin will be able to remove an executive account on the application. |
Actions |
Click remove new account Hit confirm System will remove the account
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested |
Test Case Title: Create Report
Preconditions | Executive will be able to create report of database using the application |
Actions |
Hit create report Enter the data Hit enter
|
Expected Results | If there is an error at any stage system will display it. |
Tested By: | |
Result: | Tested Smart ETL Tool Design Phase |