For example, you can replicate from small column data lengths at the source to larger data lengths at the target.
例如,您可以将源系统上较小的列数据长度复制为目标系统上较大的数据长度。
Recall that the input string contains a full timestamp with date and time information, and you want to populate the TIMECHANGED column in the DB2 target table with only a time value.
记住,输入字符串包含一个带有日期和时间信息的完整时间戳,您希望仅使用一个时间值填充db 2目标表中的timechanged列。
The real value of this particular column isn't in esoteric code, but simply in communicating a clear notion of the target you should have for enabling your own remote service.
这篇特别的专栏文章的真正价值并不在于深奥的代码,而只是在于传达了一个清晰的概念,您应该以此为目标来启用自己的远程服务。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
在随后的数据流操作中,您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
It is not required to have this data on the target system to see the column analysis or rule execution results.
要查看列分析或规则执行在目标系统上不一定要有这些数据。
In some cases, it may be more convenient to have the transform column sorted by the target outputs.
某些情况下,按照目标输出对转换列进行排序会更方便。
With all the necessary relational values extracted from the source XML column, it's time to aggregate the two values needed for one of the target data warehouse tables (the DWADMIN.ACCT table).
从源xml列提取所有需要的关系值之后,便可以为一个目标数据仓库表(DWADMIN .acct表)聚合这两个值。
CLI target column support for the LOAD utility.
LOAD实用程序的CLI目标列支持。
Similarly, a mapping that describes the splitting of an address field into Line1, Line2, City, ZipCode would have one source column and four target columns.
类似地,如果一个映射描述的是将address字段分割为Line1,Line2,City,ZipCode,那么它将有一个源列和4个目标列。
When performing discovery, its only data column (attrval) may appear more the once as the target field.
在执行发现时,其惟一的数据列(attrval)可能会作为目标字段不止一次出现。
Similarly the first column corresponds to an empty target word, so it is the cost of deleting 0, 1,..., I letters.
同样,第一列对应着空的目标单词,所以它就是删除0,1,…,i个字母的成本。
You see that each attribute is annotated with its path and a target column in a target table (" rowset ").
可以看到,每个属性都带有注释,其中包含该属性的路径和它在目标表中的目标列(“rowset”)。
Edit the XML Relational Mapping operator, deleting all column definitions except those required by the target table.
编辑XMLRelationalmapping操作符,删除目标表不需要的所有列定义。
The first column represents the source data type (in Roslyn's case: DB2), and the second column represents the target (Oracle) data type.
第一个列表示源数据类型(在Roslyn的例子中为:DB 2),第二个列表示目标数据类型(Oracle)。
You've now programmed the XML Input stage to extract data from a DB2 pureXML column and prepare it for mapping into a DB2 target data warehouse table that is largely relational.
现在,您已经让XMLInput阶段能够从DB 2purexml列提取数据,并将数据映射到主要是关系结构的DB 2目标数据仓库表。
Click the Source column for the author target list.
单击author目标列表的source列。
Select the Source column for the author target list.
为author目标列表选择Source列。
Click the Source column for the book target list.
单击book目标列表的source列。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
values子句还为用户指定的oid列的值包括了一个casting函数,因为该值必须强制转换成目标表的REFERENCE类型。
identitymissing no yes yes Specifies that the import or load input file does not contain any values for the identity column in the target table. Given load input file custdata.del
identitymissing noyes yes指定导入或载入输入文件不包含任何目标表中标识列的值。
The Transformer stage needs to extract time information from an input string containing timestamp data in order to correctly populate the TIMECHANGED column in the target DWADMIN.ACCT table.
Transformer阶段需要从包含时间戳数据的输入字符串提取时间信息,以准确地填充目标DWADMIN.ACCT 表中的 TIMECHANGED列。
There is another row in the source table with a value of 10 for the customer_num column, which joins with the same row in the target table.
还有其他行中列customer_num的值为10,其与目标表中的相同行联接。
The source row is shown first in the table (identified as 1 in the source column), followed by the target row (identified as 2 in the source column).
表中首先显示源行(在source列中标识为1),然后再显示目标行(在source列中标识为2)。
The column attribute specifies the column in the mapping table for the owning class that is used as the foreign key to the target class.
colum n属性指定当前类的映射表与目标类用作外键的列。
Listing 5 sets the target spreadsheet and worksheet and then creates an array of row data containing column-value mappings.
清单5设置了目标电子表格和工作表,然后创建了一个行数据数组,包含列-值映射。
The connector generates the query SQL at runtime based on the target table and the column definitions.
连接器将根据目标表和列定义在运行时生成查询s QL。
The <many-to-many> tag's column attribute specifies the foreign key column in the link table that relates the link table to the mapping table for the target class.
<many-to-many>标签中的column属性用来指定连接表与目标类的映射表链接的外键。
Use the column mapping field to change the default mapping of source columns to columns in the non-DB2 target table.
使用Columnmapping字段来修改非db 2目标表中源列到列的默认映射。
The search uses a special target pattern (namely: \%column_numv.*\S) to locate the closest preceding line that has a non-whitespace character (\S) at or after (.*) the cursor column (\%column_numv).
搜索使用了一个特殊的目标模式(即 \%column_numv.*\S)来查找最近的一个行,这个行在游标所处的这一列(\%column_numv)或后一列(.*)应当具有一个非空字符(\S)。
The search uses a special target pattern (namely: \%column_numv.*\S) to locate the closest preceding line that has a non-whitespace character (\S) at or after (.*) the cursor column (\%column_numv).
搜索使用了一个特殊的目标模式(即 \%column_numv.*\S)来查找最近的一个行,这个行在游标所处的这一列(\%column_numv)或后一列(.*)应当具有一个非空字符(\S)。
应用推荐