Project Login
Registration No:
Password:
MAIL ALERTS SMS ALERTS
 
     
   
     

EXTRACT TRANSFORM AND LOAD (ETL)

Platform : JAVA

Non IEEE Project : 2011

EXTRACT TRANSFORM AND LOAD (ETL) ABSTRACT Extract, Transform, and Load (ETL) is a process in data warehousing that involves  Extracting data from outside sources. Common data source formats are relational databases and flat files. Extraction converts the data into a format for transformation processing. ETL is important, as it is the way data actually gets loaded into the warehouse. Term ETL can in fact refer to a process that loads any database.  Transforming it to fit business needs (which can include quality levels) . The transform stage applies a series of rules or functions to the extracted data from the source to derive the data to be loaded to the end target. Selecting only certain columns to load (or selecting null columns not to load)  Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female), this is called automated data cleansing; no manual cleansing occurs during ETL  Some data sources will require very little or even no manipulation of data and ultimately,  Loading it into the end target, i.e. the data warehouse. As the load phase interacts with a database, the constraints defined in the database schema as well as in triggers activated upon data load apply. As the load phase interacts with a database, the constraints defined in the database schema as well as in triggers activated upon data load apply. Modules: • Extract • Load • Transform Current system: In the existing system there are some of the disadvantages as described below • Data is scattered over the different databases. • Many versions, subtle differences. • Available data poorly documented. • Results are unexpected. • Data needs to be transformed from one form to other. • Analyzing of the business is not possible as historical data is not present. • Transaction is very slow as data is continuously loading to centralized database referred as OLTP. Proposed system: Here are many benefits of the proposed system, Improve business with informative data analysis. The system help’s Business Analyst to do their jobs more effectively and efficiently. With a single, enterprise wide view of real time information it allow decision makers to access and analyze the correlations between: • Targeted and direct marketing. • Customer retention; • Management accounting. • Market and credit risk. • Fraud detection. • Historical business trends. • Product gaps and opportunities. • Activity and performance. • Market segmentation. • Competitor products. System requirements: Hardware requirements: Processor : Intel Pentium IV RAM : 512 MB or more Hard disk : 20 GB Software requirements: Operating system : Windows 2000/xp Technologies : JAVA (JSP, JDBC, HTML) Data Base : Oracle 10g, MS Access Server : Tomcat Server

NOW GET PROJECTS ! GET TRAINED ! GET PLACED !

IEEE, NON-IEEE, REAL TIME LIVE ACADEMIC PROJECTS,

PROJECTS WITH COMPLETE COURSES,SOFT SKILLS & PLACEMENTS

ALLOVER INDIA & WORLD WIDE,

HOSTEL FACILITY AVAILABLE FOR GIRLS & BOYS SEPARATELY,

CALL: 08985129129 ,  E-Mail Id: support@ascentit.in

REGISTER FOR PROJECTS NOW ! GET DISCOUNT
   
1