Data Transfers in to A Database - Buisness Management - Lecture Slides, Slides of Business Administration

Download Data Transfers in to A Database - Buisness Management - Lecture Slides and more Slides Business Administration in PDF only on Docsity! Data transfers into a database • First time system implementation – From a manual system • Data warehousing projects • Database version upgrade • ERP projects • Migration – From old to new system Docsity.com Data transfers between systems • Dynamic data (eg. sales orders) – Interface required? • Static data (eg. customers) – Conversion required? Docsity.com Labour intensive tasks • Data entry • Data checks • Working on solving conflicts • Allocating new codes • Solution = introduce as much automation as possible – SQL / SQL loader (Oracle) – Custom conversion programmes to extract, modify and upload data – Filtering – Parsing (eg: excel) – Staging areas for conversion in progress Docsity.com Data utilities • ORACLE is king of data handling • Export: to transfer data between DBs – Extract both table structure and data content into dump file • Import: corresponding facility • SQL*loader automatic import from a variety of file formats into DB files – Needs a control file Docsity.com Control files: using SQLloader • Data tranfers in and out of DB can be automated using the loader – Create a data file with the data(!) – Create a control file to guide the operation • Load creates two files – Log file – “bad transactions” file • Also a discard file if control file has selection criteria in it Docsity.com Example 2 – New Cost Accounting Structure Maintenance department expenditure: 1 account => separate accounts for different production activities Intervention code Desc. Date LabourParts Total OLD Docsity.com Example 2 – New Cost Accounting Structure Maintenance department expenditure: 1 account => separate accounts for different production activities Intervention code Desc. Date LabourParts Total Intervention code Desc. Date labour Parts Total Account OLD NEW Docsity.com Example 3: merging files • Complete customer file based on Accounts and Sales and Shipping OLD (finance) CustID name address city account number credit limit balance OLD (sales) OLD (Shipping) CustID* name address city discount rates sales_to_date rep_name CustID** name address city Preferred haulier Docsity.com