Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Data Warehousing - CS614 > Chapter 41 > Flashcards

Chapter 41 Flashcards

1
Q

What is DTS

A

Data Transformation Services (DTS) is a set of graphical tools and programmable objects that allow you extract, transform, and consolidate data from disparate sources into single or multiple destinations. SQL Server Enterprise Manager provides an easy access to the tools of DTS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is transformation of data

A

Transformation brings data in some standard format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Microsoft SQL Server provides support for basic transformation. How complex transformation done

A

Complex transformations are achieved through VB Script or Java Script that is loaded in DTS package. Package can also be programmed by using DTS object model instead of using graphical tools but DTS programming is rather complicated.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is DTS task

A

DTS task is a unit of work in a package

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is workflow of a package in DTS

A

This order or sequence of execution of tasks is called workflow of a package

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is DTS package

A

A DTS package is an organized collection of connections, DTS tasks, DTS transformations, and workflow constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How DTS package works

A

When package runs, it connects to data sources, copies data and database objects, transform data, notify other users or processes of the events.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are 2 GUI tools by Microsoft for building a package

A
  1. Import/Export Wizard

2. DTS Designer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Where we can save DTS package

A
  1. Microsoft SQL server

2. SQL Server Meta Data Services

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Is it necessary for a package to execute immediately when it build

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How we can protect package

A

User and Owner Password

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is single work item in package

A

Task

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is Message Queue task in DTS

A

Message Queue task that allows you to use Message Queuing to send and receive messages between packages.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are 9 types of transformations

A
  1. Copy Column Transformation
  2. ActiveX Script Transformation
  3. Date Time String Transformation
  4. Uppercase String Transformation
  5. Lowercase String Transformation
  6. Middle of String Transformation
  7. Trim String Transformation
  8. Read File Transformation
  9. Write File Transformation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are 3 types of DTS connection

A
  1. Data source connection
  2. File connection
  3. Data link connection
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are 3 types of constraints in DTS

A
  1. Unconditional
  2. On Success
  3. On Failure

Data Warehousing - CS614 (45 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions