遗传学 发表于 2025-3-23 09:41:36

XML Data Sources,m, XML files are now being used in their place. Certainly XML has its faults—and file size is not the least of them, especially when compared to text file source data. But for sheer reliability and ease of debugging XML-based data loads, I prefer to use XML files as source data over flat files any time.

危机 发表于 2025-3-23 16:57:36

http://reply.papertrans.cn/87/8603/860284/860284_12.png

Vasodilation 发表于 2025-3-23 19:21:10

Data Transformation,to an SQL Server destination database. Frequently, however, many changes must be applied to the data as it progresses from source to destination. Consequently, this chapter will look at some of the major data transformation challenges that face the ETL developer.

Electrolysis 发表于 2025-3-24 00:49:37

Flat File Data Sources,For more years than most of us care to remember, the single most common source of external data facing an SQL Server developer or DBA was a text file. The inevitable consequence of the near ubiquity of the “flat” file is the minor ecosystem of tools and techniques that has grown over time to help us all load text file data sources into SQL Server.

NATAL 发表于 2025-3-24 03:23:27

Metadata,Metadata is data about data. Specifically, in the context of data ingestion processes, it means discovering and knowing all that is necessary to know about the structures of your source data. This means having, at a minimum, all the details of the following:

LVAD360 发表于 2025-3-24 08:13:56

http://reply.papertrans.cn/87/8603/860284/860284_16.png

Ptosis 发表于 2025-3-24 13:03:38

http://reply.papertrans.cn/87/8603/860284/860284_17.png

Hiatal-Hernia 发表于 2025-3-24 18:12:31

http://reply.papertrans.cn/87/8603/860284/860284_18.png

无孔 发表于 2025-3-24 20:55:32

http://reply.papertrans.cn/87/8603/860284/860284_19.png

Impugn 发表于 2025-3-24 23:26:24

rver, helping to create robust and resilient ETL environment.SQL Server 2012 Data Integration Recipes. provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? .
页: 1 [2] 3 4 5 6
查看完整版本: Titlebook: SQL Server 2012 Data Integration Recipes; Solutions for Integr Adam Aspin Book 2012 Adam Aspin 2012