| Key | Value |
|---|---|
node_type | Unmapped |
raw | <step> <name>Insert / update fact purchases</name> <type>InsertUpdate</type> <description/> <distribute>Y</distribute> <custom_distribution/> <copies>1</copies> <partitioning> <method>none</method> <schema_name/> </partitioning> <connection>mySql_eae_Dm</connection> <commit>100</commit> <update_bypassed>N</update_bypassed> <lookup> <schema>eae_data_management_mmjja</schema> <table>fact_purchases</table> <key> <name>PurchaseOrderDetailID</name> <field>purchase_order_detail_id</field> <condition>=</condition> <name2/> </key> <value> <name>purchase_order_id</name> <rename>PurchaseOrderID</rename> <update>N</update> </value> <value> <name>purchase_order_detail_id</name> <rename>PurchaseOrderDetailID</rename> <update>N</update> </value> <value> <name>received_flag</name> <rename>calculated_received_flag</rename> <update>Y</update> </value> <value> <name>stocked_amount</name> <rename>calculated_stocked_amount</rename> <update>Y</update> </value> <value> <name>received_amount</name> <rename>calculated_received_amount</rename> <update>Y</update> </value> <value> <name>rejected_amount</name> <rename>calculated_rejected_amount</rename> <update>Y</update> </value> <value> <name>stocked_qty</name> <rename>StockedQty</rename> <update>Y</update> </value> <value> <name>received_qty</name> <rename>ReceivedQty</rename> <update>Y</update> </value> <value> <name>rejected_qty</name> <rename>RejectedQty</rename> <update>Y</update> </value> <value> <name>order_amount</name> <rename>LineTotal</rename> <update>Y</update> </value> <value> <name>order_qty</name> <rename>OrderQty</rename> <update>Y</update> </value> <value> <name>product_unit_price</name> <rename>UnitPrice</rename> <update>Y</update> </value> <value> <name>dim_product_id</name> <rename>dim_product_id</rename> <update>Y</update> </value> <value> <name>dim_vendor_id</name> <rename>dim_vendor_id</rename> <update>Y</update> </value> <value> <name>ship_date_datetime</name> <rename>ShipDate</rename> <update>Y</update> </value> <value> <name>ship_date_id</name> <rename>calculated_ship_date_id</rename> <update>Y</update> </value> <value> <name>order_date_datetime</name> <rename>OrderDate</rename> <update>Y</update> </value> <value> <name>order_date_id</name> <rename>calculated_order_date_id</rename> <update>Y</update> </value> </lookup> <attributes/> <cluster_schema/> <remotesteps> <input> </input> <output> </output> </remotesteps> <GUI> <xloc>704</xloc> <yloc>64</yloc> <draw>Y</draw> </GUI> </step> |
reason | unrecognized step type: InsertUpdate |
bc5e6ac3-c306-5ec8-850f-c5ac0d6afd57graph TD
n6331067b8cd053c791f2feb9791df119["fact_purchase.ktr:6"]
nbc5e6ac3c3065ec8850fc5ac0d6afd57["fact_purchase.ktr:1"]
nbc5e6ac3c3065ec8850fc5ac0d6afd57 -->|FeedsInto| n6331067b8cd053c791f2feb9791df119
5a3f8261-e177-5f55-b408-fa8fe846a2ff — <step>
<name>Insert / update fact purchases</name>
<type>InsertUpdate</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name/>
</partitioning>
<connection>mySql_eae_Dm</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema>eae_data_management_mmjja</schema>
<table>fact_purchases</table>
<key>
<name>PurchaseOrderDetailID</name>
<field>purchase_order_detail_id</field>
<condition>=</condition>
<name2/>
</key>
<value>
<name>purchase_order_id</name>
<rename>PurchaseOrderID</rename>
<update>N</update>
</value>
<value>
<name>purchase_order_detail_id</name>
<rename>PurchaseOrderDetailID</rename>
<update>N</update>
</value>
<value>
<name>received_flag</name>
<rename>calculated_received_flag</rename>
<update>Y</update>
</value>
<value>
<name>stocked_amount</name>
<rename>calculated_stocked_amount</rename>
<update>Y</update>
</value>
<value>
<name>received_amount</name>
<rename>calculated_received_amount</rename>
<update>Y</update>
</value>
<value>
<name>rejected_amount</name>
<rename>calculated_rejected_amount</rename>
<update>Y</update>
</value>
<value>
<name>stocked_qty</name>
<rename>StockedQty</rename>
<update>Y</update>
</value>
<value>
<name>received_qty</name>
<rename>ReceivedQty</rename>
<update>Y</update>
</value>
<value>
<name>rejected_qty</name>
<rename>RejectedQty</rename>
<update>Y</update>
</value>
<value>
<name>order_amount</name>
<rename>LineTotal</rename>
<update>Y</update>
</value>
<value>
<name>order_qty</name>
<rename>OrderQty</rename>
<update>Y</update>
</value>
<value>
<name>product_unit_price</name>
<rename>UnitPrice</rename>
<update>Y</update>
</value>
<value>
<name>dim_product_id</name>
<rename>dim_product_id</rename>
<update>Y</update>
</value>
<value>
<name>dim_vendor_id</name>
<rename>dim_vendor_id</rename>
<update>Y</update>
</value>
<value>
<name>ship_date_datetime</name>
<rename>ShipDate</rename>
<update>Y</update>
</value>
<value>
<name>ship_date_id</name>
<rename>calculated_ship_date_id</rename>
<update>Y</update>
</value>
<value>
<name>order_date_datetime</name>
<rename>OrderDate</rename>
<update>Y</update>
</value>
<value>
<name>order_date_id</name>
<rename>calculated_order_date_id</rename>
<update>Y</update>
</value>
</lookup>
<attributes/>
<cluster_schema/>
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>704</xloc>
<yloc>64</yloc>
<draw>Y</draw>
</GUI>
</step> (confidence: 1.00)Live rendering added for this hosted example via mermaid.js (CDN). The ekos docs generate tool itself ships the diagram as source only, to stay fully offline by default.