📄 dm data sets.dtsx
字号:
</connector>
</ddscontrol>
</dds></dwd:Layout><dwd:PersistedViewPortTop>846</dwd:PersistedViewPortTop></dwd:DtsControlFlowDiagram></Package></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{B1EF4FCD-822A-4AA2-878F-15A1757E6350}</DTS:Property><DTS:Property DTS:Name="DTSID">{13D7F8DE-1ED6-4250-9CDE-A6A12BB0C471}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><ConnectionManager xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:DataSourceID>Adventure Works DW</dwd:DataSourceID></ConnectionManager></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{BD7F5272-9449-4ECC-B045-CA8FDC54FF4A}</DTS:Property><DTS:Property DTS:Name="DTSID">{1A0403AF-34E1-431D-85E5-8D3C4ADFB969}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable>
<DTS:PackageVariable><DTS:Property DTS:Name="PackageVariableValue" DTS:DataType="8"><PrecedenceConstraint xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"><dwd:EvalOp>Constraint</dwd:EvalOp></PrecedenceConstraint></DTS:Property><DTS:Property DTS:Name="Namespace">dts-designer-1.0</DTS:Property><DTS:Property DTS:Name="ObjectName">{F2ED8A0F-B6F9-4C27-AE01-D7AEB9E80DCE}</DTS:Property><DTS:Property DTS:Name="DTSID">{B6A4FBBE-DBFA-4F42-B387-1DD343A37B5E}</DTS:Property><DTS:Property DTS:Name="Description"></DTS:Property><DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PackageVariable><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">1033</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>
<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" DTS:ThreadHint="0"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact">Execute SQL Task; Microsoft Corporation; Microsoft SQL Server v9; 漏 2004 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1</DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Create or truncate target tables</DTS:Property><DTS:Property DTS:Name="DTSID">{6C75C991-5682-4B6D-8E74-A21744DB6289}</DTS:Property><DTS:Property DTS:Name="Description">Execute SQL Task</DTS:Property><DTS:Property DTS:Name="CreationName">Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><SQLTask:SqlTaskData SQLTask:Connection="{91E67E7D-A7FF-4EF0-A3E5-464A1C0A9E2D}" SQLTask:TimeOut="0" SQLTask:IsStoredProc="False" SQLTask:BypassPrepare="False" SQLTask:SqlStmtSourceType="DirectInput" SQLTask:SqlStatementSource="/****** Object: Table [dbo].[DMDemoCustTrain] Script Date: 07/17/2006 14:27:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DMDemoCustTrain]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
 TRUNCATE TABLE [DMDemoCustTrain]
ELSE
 CREATE TABLE [dbo].[DMDemoCustTrain](
 [CustomerKey] [int] NULL,
 [FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [MiddleName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [NameStyle] [bit] NULL,
 [BirthDate] [datetime] NULL,
 [MaritalStatus] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Gender] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [YearlyIncome] [money] NULL,
 [TotalChildren] [tinyint] NULL,
 [NumberChildrenAtHome] [tinyint] NULL,
 [EnglishEducation] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishOccupation] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [HouseOwnerFlag] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [NumberCarsOwned] [tinyint] NULL,
 [DateFirstPurchase] [datetime] NULL,
 [CommuteDistance] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [StateProvinceName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishCountryRegionName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [PostalCode] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [City] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DMDemoCustTest]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
 TRUNCATE TABLE [DMDemoCustTest]
ELSE
 CREATE TABLE [dbo].[DMDemoCustTest](
 [CustomerKey] [int] NULL,
 [FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [MiddleName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [NameStyle] [bit] NULL,
 [BirthDate] [datetime] NULL,
 [MaritalStatus] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Gender] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [YearlyIncome] [money] NULL,
 [TotalChildren] [tinyint] NULL,
 [NumberChildrenAtHome] [tinyint] NULL,
 [EnglishEducation] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishOccupation] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [HouseOwnerFlag] [nvarchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [NumberCarsOwned] [tinyint] NULL,
 [DateFirstPurchase] [datetime] NULL,
 [CommuteDistance] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [StateProvinceName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishCountryRegionName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [PostalCode] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [City] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DMDemoCustPurch]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
 TRUNCATE TABLE [DMDemoCustPurch]
ELSE
 CREATE TABLE [dbo].[DMDemoCustPurch](
 [EnglishProductName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [ProductLine] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [ModelName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishProductSubcategoryName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [EnglishProductCategoryName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [FullDateAlternateKey] [datetime] NULL,
 [SalesOrderNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [SalesOrderLineNumber] [tinyint] NULL,
 [OrderQuantity] [smallint] NULL,
 [SalesAmount] [money] NULL,
 [CustomerKey] [int] NULL,
 [ProductKey] [int] NULL
) ON [PRIMARY]
" SQLTask:ResultType="ResultSetType_None" xmlns:SQLTask="www.microsoft.com/sqlserver/dts/tasks/sqltask"/></DTS:ObjectData></DTS:Executable>
<DTS:Executable DTS:ExecutableType="{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}"><DTS:Property DTS:Name="ExecutionLocation">0</DTS:Property><DTS:Property DTS:Name="ExecutionAddress"></DTS:Property><DTS:Property DTS:Name="TaskContact"></DTS:Property><DTS:Property DTS:Name="ForceExecValue">0</DTS:Property><DTS:Property DTS:Name="ExecValue" DTS:DataType="3">0</DTS:Property><DTS:Property DTS:Name="ForceExecutionResult">-1</DTS:Property><DTS:Property DTS:Name="Disabled">0</DTS:Property><DTS:Property DTS:Name="FailPackageOnFailure">0</DTS:Property><DTS:Property DTS:Name="FailParentOnFailure">0</DTS:Property><DTS:Property DTS:Name="MaxErrorCount">1</DTS:Property><DTS:Property DTS:Name="ISOLevel">1048576</DTS:Property><DTS:Property DTS:Name="LocaleID">-1</DTS:Property><DTS:Property DTS:Name="TransactionOption">1</DTS:Property><DTS:Property DTS:Name="DelayValidation">0</DTS:Property>
<DTS:LoggingOptions><DTS:Property DTS:Name="LoggingMode">0</DTS:Property><DTS:Property DTS:Name="FilterKind">1</DTS:Property><DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions><DTS:Property DTS:Name="ObjectName">Create Customer Sets</DTS:Property><DTS:Property DTS:Name="DTSID">{79A2DB68-09E4-4474-AC0B-FD2AA3BE5AC6}</DTS:Property><DTS:Property DTS:Name="Description">Data Flow Task</DTS:Property><DTS:Property DTS:Name="CreationName">{C3BF9DC1-4715-4694-936F-D3CFDA9E42C5}</DTS:Property><DTS:Property DTS:Name="DisableEventHandlers">0</DTS:Property><DTS:ObjectData><pipeline id="0" name="pipelineXml" description="pipelineXml" defaultBufferMaxRows="10000" engineThreads="5" defaultBufferSize="10485760" BLOBTempStoragePath="" bufferTempStoragePath="" runInOptimizedMode="true">
<components>
<component id="397" name="Percentage Sampling" componentClassID="{481EA6F5-D9F0-4AF4-AA73-466D0390826B}" description="Percentage Sampling Transformation" localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Percentage Sampling;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">
<properties>
<property id="398" name="SamplingValue" dataType="System.Int32" state="default" isArray="false" description="Specifies the percentage size of the sample." typeConverter="" UITypeEditor="" containsID="false" expressionType="Notify">10</property>
<property id="399" name="SamplingSeed" dataType="System.Int32" state="default" isArray="false" description="Specifies the seed for the random number generator." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property></properties>
<inputs>
<input id="400" name="Percentage Sampling Input 1" description="" hasSideEffects="false" dangling="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><externalMetadataColumns isUsed="False"/></input>
</inputs>
<outputs>
<output id="401" name="Test Data Set" description="" exclusionGroup="1" synchronousInputId="400" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><properties>
<property id="402" name="Selected" dataType="System.Boolean" state="default" isArray="false" description="Output for rows in the sample" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property></properties><externalMetadataColumns isUsed="False"/></output>
<output id="403" name="Training Data Set" description="" exclusionGroup="1" synchronousInputId="400" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><properties>
<property id="404" name="Selected" dataType="System.Boolean" state="default" isArray="false" description="Output for rows in the sample" typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties><externalMetadataColumns isUsed="False"/></output>
</outputs>
</component>
<component id="71" name="Select Customer Rows" componentClassID="{2C0A8BE5-1EDC-4353-A0EF-B778599C65A0}" description="OLE DB Source" localeId="-1" usesDispositions="true" validateExternalMetadata="True" version="7" pipelineVersion="0" contactInfo="OLE DB Source;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5">
<properties>
<property id="72" name="CommandTimeout" dataType="System.Int32" state="default" isArray="false" description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">0</property>
<property id="73" name="OpenRowset" dataType="System.String" state="default" isArray="false" description="Specifies the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">[dbo].[DimCustomer]</property>
<property id="74" name="OpenRowsetVariable" dataType="System.String" state="default" isArray="false" description="Specifies the variable that contains the name of the database object used to open a rowset." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
<property id="75" name="SqlCommand" dataType="System.String" state="default" isArray="false" description="The SQL command to be executed." typeConverter="" UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor, Microsoft.DataTransformationServices.Controls, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" containsID="false" expressionType="None">SELECT DimCustomer.CustomerKey, DimCustomer.FirstName, DimCustomer.MiddleName, DimCustomer.LastName, DimCustomer.NameStyle,
DimCustomer.BirthDate, DimCustomer.MaritalStatus, DimCustomer.Gender, DimCustomer.YearlyIncome, DimCustomer.TotalChildren,
DimCustomer.NumberChildrenAtHome, DimCustomer.EnglishEducation, DimCustomer.EnglishOccupation, DimCustomer.HouseOwnerFlag,
DimCustomer.NumberCarsOwned, DimCustomer.DateFirstPurchase, DimCustomer.CommuteDistance, DimGeography.StateProvinceName,
DimGeography.EnglishCountryRegionName, DimGeography.PostalCode, DimGeography.City
FROM DimCustomer INNER JOIN
DimGeography ON DimCustomer.GeographyKey = DimGeography.GeographyKey</property>
<property id="76" name="SqlCommandVariable" dataType="System.String" state="default" isArray="false" description="The variable that contains the SQL command to be executed." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
<property id="77" name="DefaultCodePage" dataType="System.Int32" state="default" isArray="false" description="Specifies the column code page to use when code page information is unavailable from the data source." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">1252</property>
<property id="78" name="AccessMode" dataType="System.Int32" state="default" isArray="false" description="Specifies the mode used to access the database." typeConverter="AccessMode" UITypeEditor="" containsID="false" expressionType="None">2</property>
<property id="84" name="ParameterMapping" dataType="System.String" state="default" isArray="false" description="The mappings between the parameters in the SQL command and variables." typeConverter="" UITypeEditor="" containsID="false" expressionType="None"></property>
<property id="556" name="AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property></properties>
<connections>
<connection id="79" name="OleDbConnection" description="The OLE DB runtime connection used to access the database." connectionManagerID="{91E67E7D-A7FF-4EF0-A3E5-464A1C0A9E2D}"/></connections>
<outputs>
<output id="80" name="OLE DB Source Output" description="" exclusionGroup="0" synchronousInputId="0" deleteOutputOnPathDetached="false" hasSideEffects="false" dangling="false" isErrorOut="false" isSorted="false" errorOrTruncationOperation="" errorRowDisposition="NotUsed" truncationRowDisposition="NotUsed"><outputColumns>
<outputColumn id="100" name="CustomerKey" description="" lineageId="100" precision="0" scale="0" length="0" dataType="i4" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="99"/>
<outputColumn id="103" name="FirstName" description="" lineageId="103" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="102"/>
<outputColumn id="106" name="MiddleName" description="" lineageId="106" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="105"/>
<outputColumn id="109" name="LastName" description="" lineageId="109" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="108"/>
<outputColumn id="112" name="NameStyle" description="" lineageId="112" precision="0" scale="0" length="0" dataType="bool" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="111"/>
<outputColumn id="115" name="BirthDate" description="" lineageId="115" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="114"/>
<outputColumn id="118" name="MaritalStatus" description="" lineageId="118" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="117"/>
<outputColumn id="121" name="Gender" description="" lineageId="121" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="120"/>
<outputColumn id="124" name="YearlyIncome" description="" lineageId="124" precision="0" scale="0" length="0" dataType="cy" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="123"/>
<outputColumn id="127" name="TotalChildren" description="" lineageId="127" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="126"/>
<outputColumn id="130" name="NumberChildrenAtHome" description="" lineageId="130" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="129"/>
<outputColumn id="133" name="EnglishEducation" description="" lineageId="133" precision="0" scale="0" length="40" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="132"/>
<outputColumn id="136" name="EnglishOccupation" description="" lineageId="136" precision="0" scale="0" length="100" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="135"/>
<outputColumn id="139" name="HouseOwnerFlag" description="" lineageId="139" precision="0" scale="0" length="1" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="138"/>
<outputColumn id="142" name="NumberCarsOwned" description="" lineageId="142" precision="0" scale="0" length="0" dataType="ui1" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="141"/>
<outputColumn id="145" name="DateFirstPurchase" description="" lineageId="145" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="144"/>
<outputColumn id="148" name="CommuteDistance" description="" lineageId="148" precision="0" scale="0" length="15" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="147"/>
<outputColumn id="780" name="StateProvinceName" description="" lineageId="780" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="779"/>
<outputColumn id="783" name="EnglishCountryRegionName" description="" lineageId="783" precision="0" scale="0" length="50" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="782"/>
<outputColumn id="786" name="PostalCode" description="" lineageId="786" precision="0" scale="0" length="15" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="785"/>
<outputColumn id="789" name="City" description="" lineageId="789" precision="0" scale="0" length="30" dataType="wstr" codePage="0" sortKeyPosition="0" comparisonFlags="0" specialFlags="0" errorOrTruncationOperation="Conversion" errorRowDisposition="FailComponent" truncationRowDisposition="FailComponent" externalMetadataColumnId="788"/></outputColumns><externalMetadataColumns isUsed="True">
<externalMetadataColumn id="99" name="CustomerKey" description="" precision="0" scale="0" length="0" dataType="i4" codePage="0"/>
<externalMetadataColumn id="102" name="FirstName" description="" precision="0" scale="0" length="50" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="105" name="MiddleName" description="" precision="0" scale="0" length="50" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="108" name="LastName" description="" precision="0" scale="0" length="50" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="111" name="NameStyle" description="" precision="0" scale="0" length="0" dataType="bool" codePage="0"/>
<externalMetadataColumn id="114" name="BirthDate" description="" precision="0" scale="0" length="0" dataType="dbTimeStamp" codePage="0"/>
<externalMetadataColumn id="117" name="MaritalStatus" description="" precision="0" scale="0" length="1" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="120" name="Gender" description="" precision="0" scale="0" length="1" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="123" name="YearlyIncome" description="" precision="0" scale="0" length="0" dataType="cy" codePage="0"/>
<externalMetadataColumn id="126" name="TotalChildren" description="" precision="0" scale="0" length="0" dataType="ui1" codePage="0"/>
<externalMetadataColumn id="129" name="NumberChildrenAtHome" description="" precision="0" scale="0" length="0" dataType="ui1" codePage="0"/>
<externalMetadataColumn id="132" name="EnglishEducation" description="" precision="0" scale="0" length="40" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="135" name="EnglishOccupation" description="" precision="0" scale="0" length="100" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="138" name="HouseOwnerFlag" description="" precision="0" scale="0" length="1" dataType="wstr" codePage="0"/>
<externalMetadataColumn id="141" name="NumberCarsOwned" description="" precision="0" scale="0" length="0" dataType="ui1⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -