The loading table are in a star schema, and for every entry in the si_work_order (header) tables there should be at
least one entry into the detail table . . .
I am trying to perform ETL, and I am having trouble figuring out how to do the following:
all new records in tbLocal_WMS_OrderStatus (tbLocal_WMS_OrderStatus STATUS=”N”) in MES_TRANS_ID order. For
each new record in tbLocal_WMS_OrderStatus, generate a record with STATUS=”N” in tbLocal_WMS_OrderStatusTransLog for each JDE work center associated with the MES execution path from tbLocal_WMS_OrderStatus identified by PATH_ID in the order the
work centers are confi
View Complete Post