Package com.orchestranetworks.addon.dint.transformation.crossreference
package com.orchestranetworks.addon.dint.transformation.crossreference
Provides classes and interfaces for creating a query transformation.
Example code for CrossReference transformation:
-
Create a mapping that allows to lookup the field '/location' from table '/root/Location' of dataset 'HR' that has field '/address' same with field 'address' from source file:
TableMapping<CSVField, EBXField> tableMapping = TableMapping.of(sourceTable, targetTable); CSVTable csvTable = sourceTable.getTable(); EBXTable ebxTable = targetTable.getTable(); tableMapping.fromSourceFieldStep(csvTable.get("address")) .crossReference(CrossReference.getInstance()) .param(CrossReference.DATASPACE, "BReference") .param(CrossReference.DATASET, "HR") .param(CrossReference.TABLE, "/root/Location") .param(CrossReference.SOURCE_FIELD, "/address") .param(CrossReference.TARGET_FIELD, "/location") .toField(ebxTable.get(Path.parse("/location")));
-
ClassDescriptionLooks up value from an EBX table.Represents a transformation function of
TransformationCategory.CROSS_REFERENCE
.