Data warehousing
This presentation is the property of its rightful owner.
Sponsored Links
1 / 43

Data Warehousing PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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

DWH-Ahsan Abdullah


Reference book

Reference Book

Carl Rabeler

MS SQL Server 2000 DTS Step-By-Step

DWH-Ahsan Abdullah


Data transformation services

Data Transformation Services

DWH-Ahsan Abdullah


Dts overview

Extract Data

Single or Multiple Destinations

Disparate Sources of data

Transform Data

ConsolidateData

DTS Overview

DTS,Graphical tools & Programmable objects

DWH-Ahsan Abdullah


Dts overview concept

Centralized Data

DTS Overview: Concept

DTS

DTS

DWH-Ahsan Abdullah


Dts overview example

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


Dts overview operations

DTS Overview: Operations

DWH-Ahsan Abdullah


Dts overview tools

DTS Overview: Tools

DWH-Ahsan Abdullah


Sql server enterprise manager

Path: Start >>Programs >> Microsoft SQL Server >> Enterprise Manager

SQL Server Enterprise Manager

DWH-Ahsan Abdullah


Dts overview market

DTS Overview: Market

DWH-Ahsan Abdullah


Dts basics

DTS Basics

DWH-Ahsan Abdullah


1 dts package

1. DTS Package

  • Connections

  • DTS tasks

  • DTS transformations

  • Workflows

DWH-Ahsan Abdullah


1 dts package contents

1. DTS Package: Contents

DWH-Ahsan Abdullah


1 dts package execution

1. DTS Package: Execution

DWH-Ahsan Abdullah


1 dts package creating

1. DTS Package: Creating

  • Import/Export wizard

  • DTS Designer

  • Programming DTS applications

DWH-Ahsan Abdullah


1 dts package import export wizard

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


1 dts package import export wizard1

1. DTS Package: Import/Export Wizard

DWH-Ahsan Abdullah


1 dts package import export wizard2

1. DTS Package: Import/Export Wizard

DWH-Ahsan Abdullah


1 dts package designer

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


1 dts package designer1

1. DTS Package: Designer

A

C

Design Area

B

DWH-Ahsan Abdullah


1 dts package designer2

1. DTS Package: Designer

DWH-Ahsan Abdullah


1 dts package programming

1. DTS Package: Programming

DWH-Ahsan Abdullah


1 dts package saving

1. DTS Package: Saving

DWH-Ahsan Abdullah


1 dts package saving1

1. DTS Package: Saving

DWH-Ahsan Abdullah


1 dts package saving2

1. DTS Package: Saving

Contains Packages that are saved to this particular instance of SQL Server

DWH-Ahsan Abdullah


1 dts package saving3

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


1 dts package saving4

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


1 dts package operations

1. DTS Package: Operations

DWH-Ahsan Abdullah


1 dts package editing

1. DTS Package: Editing

DWH-Ahsan Abdullah


1 dts package password protection

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


1 dts package scheduling execution

1. DTS Package: Scheduling/Execution

DWH-Ahsan Abdullah


1 dts package versioning

1. DTS Package: Versioning

DWH-Ahsan Abdullah


2 dts tasks

2. DTS Tasks

DWH-Ahsan Abdullah


2 dts tasks cont

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


3 dts transformations

3. DTS Transformations

DWH-Ahsan Abdullah


3 dts transformations available

3. DTS Transformations: Available

DWH-Ahsan Abdullah


3 dts transformations customized

3. DTS Transformations: Customized

DWH-Ahsan Abdullah


3 dts transformations cont

3. DTS Transformations (Cont.)

  • ActiveX Script

DWH-Ahsan Abdullah


4 dts connections

4. DTS Connections

DWH-Ahsan Abdullah


4 dts connections 3 slides

4. DTS Connections (3 SLIDES.)

DWH-Ahsan Abdullah


4 dts connections cont

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


5 package workflow

Task D

On completion

On Success

Task A

Task C

Task B

On Failure

Task E

5. Package workflow

DWH-Ahsan Abdullah


5 package workflow designer

5. Package workflow (DESIGNER)

DWH-Ahsan Abdullah


  • Login