Page Comparison

In this page:

Overview

Warehouse Position inbound interface was designed to load and update data to the following database tables:

...

The Warehouse Position inbound interface has 3 modes for loading data into the DB table:
Batch Mode
Single Row Upsert Mode

Roll Up

Roll Up summs sums up some numeric values from Position Detail DB table and inserts the result values into the fields of Position DB table.

...

Click to read more about Roll Up

Position Detail Analytics Switch Logic

Position Detail Analytics Switch controls the way you load elements of the Position Analytics Model to Position Analytics tables.

XML path: EagleML/warehouseTransaction/warehousePosition/posDetAnlSwitch

Valid values:

• NONE - do not load data to any Position Analytics tables;
• ANL - load to POSITION_DETAIL_ANL table only;
• ANL_EQ - load to POSITION_DETAIL_ANL_EQ table only;
• ANL_FI - load to POSITION_DETAIL_ANL_FI table only;
• ANL_KRD - load to POSITION_DETAIL_ANL_KRD table only;
• ANL_USER - load to POSITION_DETAIL_ANL_USER table only.
• ALL - load to all tables (POSITION_DETAIL_ANL, POSITION_DETAIL_ANL_EQ, POSITION_DETAIL_ANL_FI, POSITION_DETAIL_ANL_KRD, POSITION_DETAIL_ANL_USER);

Fragment of the data message to load <pricingSpread> to HOLDINGDBO.POSITION_DETAIL_ANL.PRICING_SPREAD:

...
<posDetAnlSwitch>ANL</posDetAnlSwitch>
...
<analytics>
   <pricingSpread>157.27</pricingSpread>
</analytics>
...