摘要：Acknowledgments xvIntroduction xviiChapter 1 Dimensional Modeling Primer 1Different Information Worlds 2Goals of a Data Warehouse 2The Publishing Metaphor 4Components of a Data Warehouse 6Operational Source Systems 7Data Staging Area 8Data Presentation 10Data Access Tools 13Additional Considerations 阅读全文

摘要：This termMeans thisSSIS packageA discrete executable unit of work composed of a collection of control flow and other objects, including data sources, transformations, process sequence, and rules, error and event handling, and data destinations.ContainersPackage objects that provide structure to pack 阅读全文

摘要：So far, you've learned about SSIS objects and process control architecture. Now you will learn about the SSIS components that you use to design, test, deploy, manage, schedule, and execute SSIS packages. Some of the SSIS components reside on the SSIS server, whereas other components reside on yo 阅读全文

摘要：A significant advancement to SSIS is the package architecture design for its process control management. You've already learned that the SSIS process control architecture includes the control flow, data flow, and event handler components. Each of these process control components includes common 阅读全文

摘要：Before you begin learning how to create SSIS applications, it is important to familiarize yourself first with the SSIS process control components and the objects used to create SSIS applications. The first object to note within SSIS is the package.An SSIS package is the highest-level object within a 阅读全文

摘要：One common use for SSIS is to move data from one data source to another. The reasons for moving data are too numerous to count. Some common business reasons for using SSIS include migrating business data from one application to another, extracting data for distribution to external entities, integrat 阅读全文

摘要：以下是网上摘录的UE 技巧1）删除空行: 替换 %[ ^t]++^p 为 空串2）删除行尾空格: 替换 [ ^t]+$ 为 空串3）删除行首空格: 替换 %[ ^t]+ 为 空串4）每行设置为固定的4个空格开头: 替换 %[ ^t]++^([~ ^t^p]^) 为 " ^1"5）每段设置为固定的4个空格开头: 替换 %[ ^t]+ 为 " " (如果一行是以空格开始的,则视之为一段的开始行)6）将一段合并为一行: 替换 [ ^t]++^p^([~ ^t^p]^) 为 ^1 (注意: 此处假定文本是以DOS方式回车换行 - CR/LF)7）去掉HTML T 阅读全文

摘要：OLTP 与数据仓库--有何差异？在日常生活中，我们要使用大量的应用程序来生成新的数据、变更数据、删除数据，当然在大多数的情况下我们还要查阅和分析数据。就来想象一个 收发 email 的简单应用程序吧。我们已经存储了地址信息，可能还存储了一些文档。我们可以决定是否存储已经发送过的邮件，但是也可能隔一段时间后将其删除，或者删除已 经发送过的所有邮件。那么我们该如何处理一段时间以前删除或者修改过的地址呢？我们再也不会看到它们了。Email 程序大部分都属于不是很复杂的数据库，但是完全可以将其看作一个在单用户环境下的 OLTP（在线事务处理系统）简单示例。它使用了所有的所谓访问数据的操作 CRUD（ 阅读全文