1 / 43

Data Warehousing

Virtual University of Pakistan. Data Warehousing. Lab Lect-1 DTS: Introduction. Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad. Reference Book. Carl Rabeler

tanith
Download Presentation

Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Virtual University of Pakistan Data Warehousing Lab Lect-1 DTS: Introduction Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad DWH-Ahsan Abdullah

  2. Reference Book Carl Rabeler MS SQL Server 2000 DTS Step-By-Step DWH-Ahsan Abdullah

  3. Data Transformation Services DWH-Ahsan Abdullah

  4. Extract Data Single or Multiple Destinations Disparate Sources of data Transform Data ConsolidateData DTS Overview DTS,Graphical tools & Programmable objects DWH-Ahsan Abdullah

  5. Centralized Data DTS Overview: Concept DTS DTS DWH-Ahsan Abdullah

  6. MUHAMMED ANWAR 8-JUN-1968 CH MUHMD. ASLAM 23-Nov-1980 DTS MOHAMMAD ANWAR 08/06/1968 CHOUDHARY MOHAMMAD ASLAM 23/11/1980 AHMAD JAHANZEB 05/08/1980 MOHAMMAD FARRUKH 08/11/1979 DTS AHMED JAHANZEB 8-5-80 M. FARRUKH 11-8-79 DTS Overview: Example DWH-Ahsan Abdullah

  7. DTS Overview: Operations DWH-Ahsan Abdullah

  8. DTS Overview: Tools DWH-Ahsan Abdullah

  9. Path: Start >>Programs >> Microsoft SQL Server >> Enterprise Manager SQL Server Enterprise Manager DWH-Ahsan Abdullah

  10. DTS Overview: Market DWH-Ahsan Abdullah

  11. DTS Basics DWH-Ahsan Abdullah

  12. 1. DTS Package • Connections • DTS tasks • DTS transformations • Workflows DWH-Ahsan Abdullah

  13. 1. DTS Package: Contents DWH-Ahsan Abdullah

  14. 1. DTS Package: Execution DWH-Ahsan Abdullah

  15. 1. DTS Package: Creating • Import/Export wizard • DTS Designer • Programming DTS applications DWH-Ahsan Abdullah

  16. 1. DTS Package: Import/Export Wizard • Expand tree node ‘Data Transformation Services’ and select the option for available location to save package • Tool>Data Transfer Service> Import/Export DWH-Ahsan Abdullah

  17. 1. DTS Package: Import/Export Wizard DWH-Ahsan Abdullah

  18. 1. DTS Package: Import/Export Wizard DWH-Ahsan Abdullah

  19. 1. DTS Package: Designer • Expand tree node ‘Data Transformation Services’ and select the option for available location to save package • Action>New Package DWH-Ahsan Abdullah

  20. 1. DTS Package: Designer A C Design Area B DWH-Ahsan Abdullah

  21. 1. DTS Package: Designer DWH-Ahsan Abdullah

  22. 1. DTS Package: Programming DWH-Ahsan Abdullah

  23. 1. DTS Package: Saving DWH-Ahsan Abdullah

  24. 1. DTS Package: Saving DWH-Ahsan Abdullah

  25. 1. DTS Package: Saving Contains Packages that are saved to this particular instance of SQL Server DWH-Ahsan Abdullah

  26. 1. DTS Package: Saving Contains Packages that are saved to Meta Data Services of this instance of SQL Server. It maintains version information of each packagesaved to it. DWH-Ahsan Abdullah

  27. 1. DTS Package: Saving It is a repository of metadata information of databases scanned to Meta Data ServicesPackages. It also provides version tracking facility of Packages. DWH-Ahsan Abdullah

  28. 1. DTS Package: Operations DWH-Ahsan Abdullah

  29. 1. DTS Package: Editing DWH-Ahsan Abdullah

  30. 1. DTS Package: Password protection • Save dialog box allows to set passwords • Owner password puts limits on both editing and execution of the package DWH-Ahsan Abdullah

  31. 1. DTS Package: Scheduling/Execution DWH-Ahsan Abdullah

  32. 1. DTS Package: Versioning DWH-Ahsan Abdullah

  33. 2. DTS Tasks DWH-Ahsan Abdullah

  34. 2. DTS Tasks (Cont.) Set of all possible tasks in designer, drag the required task in design area and set its properties DWH-Ahsan Abdullah

  35. 3. DTS Transformations DWH-Ahsan Abdullah

  36. 3. DTS Transformations: Available DWH-Ahsan Abdullah

  37. 3. DTS Transformations: Customized DWH-Ahsan Abdullah

  38. 3. DTS Transformations (Cont.) • ActiveX Script DWH-Ahsan Abdullah

  39. 4. DTS Connections DWH-Ahsan Abdullah

  40. 4. DTS Connections (3 SLIDES.) DWH-Ahsan Abdullah

  41. 4. DTS Connections (Cont.) Set of all possible connections in designer, drag the required connection in design area and set its properties Data source connection File connection Data link connection DWH-Ahsan Abdullah

  42. Task D On completion On Success Task A Task C Task B On Failure Task E 5. Package workflow DWH-Ahsan Abdullah

  43. 5. Package workflow (DESIGNER) DWH-Ahsan Abdullah

More Related