rel hier mapping
Icon |
|
|---|---|
Use When |
Data needs to be mapped from a relational model to a hierarchical one |
Samples |
|
Description |
The mapping component allows you to map relatiional messages to hierarchical messages |
Inbound Message Type |
Model Based Message |
Output Message Type |
Model Based Message |
| Name | Description |
|---|---|
Set Unmapped Attributes To Null |
Whether attributes in the output model that don’t have a mapping specified from the input model should be set to null. |
Hierarchical Query Method |
Determines the method by which hierarchical relationships are formed from the relational data. Either BY_QUERY or BY_JOIN. Defaults to by join. Using the BY_JOIN method, relational data is sent to the relational / hierarchical mapper based on a single joined query from an rdbms reader. When the joined data comes in to the mapper, it completes control/break logic on the data to transform it into the hierarchical model. The control break logic is based on foreign key definitions in the relational model. Using the BY_QUERY method allows one or more queries to be run from one or more rdbms readers for each entity in the hierarchical model. |
