If you want tables of the target container to be named like those of source, press the Auto assign button and the Target column will be automatically populated. To define the mapping setting for a column in a target table, release the list of source table columns by pressing next to the table's name in the Source column, then click the name of the target column and enter a new one or select one from the dropdown list. Or select a table from the existing tables in the target container by pressing the Browse button You can also choose a name for a target table from the drop-down list. You can define a target table by clicking on a cell in the Target column and entering its name, or press the New button and enter a new name in the opened dialog box. You can use basic arithmetic operations and column names to construct an expression. This transformer uses expressions (namely, JEXL expressions) to calculate the cell's value. All values in the corresponding column will be set to the specified constant. All values in the corresponding column will be set to null. To do that, define column transformers by clicking on corresponding cells in the Transform column. You may also want to transform the values of some columns during the transfer. If the cells are marked with, it means that in the target table there are no columns with matching names, otherwise the names will be filled in automatically. Unassigned - this value is set by default when there is no target defined. Skip - the source data will not be transferred to the target container.Įxisting - the source data will be transferred to the table that already exists in the target container. The following options are available:Ĭreate- the source data will be populated into a newly created table or column of the target container. Mapping - contains the list of actions to be applied to the source data on data transfer. Target - contains names of the tables where the data will be transferred to. You can also see the list of columns existing in the source table by pressing Source - contains names of all the tables selected at step 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |