Package com.orchestranetworks.addon.dint.transformation.crossreference

Provides classes and interfaces for creating a query transformation.

Example code for CrossReference transformation:

  1. 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")));