link-move icon indicating copy to clipboard operation
link-move copied to clipboard

Support for mapping columns from to-one related entity in extractor attributes

Open andrus opened this issue 10 years ago • 0 comments

"Unflattenning" extractor data matrix into a normalized schema has been a pain so far. This task aims at solving a very common problem in this area. The purpose here is to automatically derive a target root entity FK value that is not present in the source extractor. This can be done by matching one of the extractor source columns against values of a target entity related to root target entity. Then the FK would be equal to PK of such related entity.

Here is how this can be mapped:

<attribute>
   <source>SOURCE_COLUMN</source>
   <target>db:to_one_rel.some_column</target>
</attribute>

Based on this an FK of "db:to_one_rel" relationship should be calculated by LinkMove.

andrus avatar Nov 17 '15 22:11 andrus