Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit

The following questions are designed to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A: Questions and Answers.

1. When does the transformation process usually occur?
2. What is the main purpose of DTS?
3. What are the source and destination types for DTS?
4. How does OLE DB make data available to any program?

Answers