2022-01-20T04:06:13.555+0100 [INFO]: Data distribution worker started
2022-01-20T04:06:13.555+0100 [INFO]: Request id: "data_load_LwlcMPxAy0_Gy2Aq0mCY4:OajTuL026cNdwx3l:sxD9QJLInmyth7mX"
2022-01-20T04:06:13.555+0100 [INFO]: Data source: "6108f77692bf2a2965b27999"
2022-01-20T04:06:13.555+0100 [INFO]: Additional parameters: {GDC_DE_SYNCHRONIZE_ALL=true, PROCESS_ID=cf02ffce-0025-4492-b037-babc0b2c9d24}
2022-01-20T04:06:13.555+0100 [INFO]: Synchronization mode: all mapped datasets (default)
2022-01-20T04:06:23.699+0100 [INFO]: Synchronized datasets: [dataset.logicnesia_dwh_dim_goods, dataset.logicnesia_mst_rate_calculation_type, dataset.logicnesia_dwh_fact_delivery_external, dataset.logicnesia_dwh_fact_delivery, dataset.logicnesia_dwh_fact_order, dataset.logicnesia_trx_vendor_tracking, dataset.logicnesia_datalake_wh_loading, dataset.logicnesia_mst_lead_time_calculation_type, dataset.logicnesia_mst_vehicle_type, dataset.logicnesia_datalake_shipment_entry, dataset.logicnesia_datalake_do_process, dataset.logicnesia_dwh_dim_expedition, dataset.v_logicnesia_dwh_aging_order, dataset.logicnesia_dwh_dim_location, dataset.logicnesia_dwh_fact_order_goods, dataset.v_logicnesia_dwh_order_difot]
2022-01-20T04:06:23.699+0100 [INFO]: 

====================== Mapping Validation ======================

Mapping Validation is OK

====================== End of Mapping Validation ======================


2022-01-20T04:06:23.700+0100 [INFO]: 

====================== Output Stage -> LDM mapping ======================


Output Stage table/view: logicnesia_datalake_do_process (full, shared) -> Dataset: dataset.logicnesia_datalake_do_process
goods_qty[INT4] -> fact.logicnesia_datalake_do_process.goods_qty{FACT}[INT]
do_posted_date[VARCHAR(2147483647)] -> doposteddate{DATE}[DATE]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
do_number[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.do_number{LABEL}[VARCHAR(10000)]
drop_name[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_location{REFERENCE}[VARCHAR(10000)]
id[BIGSERIAL] -> label.logicnesia_datalake_do_process.id{LABEL}[INT]
pickup_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.pickup_name{LABEL}[VARCHAR(10000)]
file_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.file_status{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
upload_date[DATE] -> uploaddate{DATE}[DATE]
uploaded_by[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.uploaded_by{LABEL}[VARCHAR(10000)]
do_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.do_status{LABEL}[VARCHAR(10000)]
goods_id[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_goods{REFERENCE}[VARCHAR(128)]
to_number[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.to_number{LABEL}[VARCHAR(10000)]
file_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_do_process.file_name{LABEL}[VARCHAR(10000)]

Output Stage table/view: logicnesia_datalake_shipment_entry (full, shared) -> Dataset: dataset.logicnesia_datalake_shipment_entry
priority_delivery[INT2] -> label.logicnesia_datalake_shipment_entry.prioritydelivery{LABEL}[VARCHAR(128)]
drop_name[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_location{REFERENCE}[VARCHAR(10000)]
file_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.file_name{LABEL}[VARCHAR(10000)]
uploaded_by[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.uploaded_by{LABEL}[VARCHAR(10000)]
release_date[DATE] -> releasedate{DATE}[DATE]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
external_doc_no[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.external_doc_no{LABEL}[VARCHAR(10000)]
upload_date[DATE] -> uploaddate{DATE}[DATE]
goods_qty[INT4] -> fact.logicnesia_datalake_shipment_entry.goods_qty{FACT}[INT]
posting_date[DATE] -> postingdate{DATE}[DATE]
file_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.file_status{LABEL}[VARCHAR(10000)]
priority_delivery_date[DATE] -> prioritydeliverydate{DATE}[DATE]
to_number[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.to_number{LABEL}[VARCHAR(10000)]
pickup_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.pickup_name{LABEL}[VARCHAR(10000)]
wms_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.wms_status{LABEL}[VARCHAR(10000)]
login_id[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.login_id{LABEL}[VARCHAR(10000)]
to_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_shipment_entry.to_status{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
goods_id[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_goods{REFERENCE}[VARCHAR(128)]
id[BIGSERIAL] -> label.logicnesia_datalake_shipment_entry.id{LABEL}[INT]

Output Stage table/view: logicnesia_datalake_wh_loading (full, shared) -> Dataset: dataset.logicnesia_datalake_wh_loading
delivery_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.delivery_status{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.logicnesia_datalake_wh_loading.id{LABEL}[INT]
batch_no[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.batch_no{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
volume[NUMERIC(12,2)] -> fact.logicnesia_datalake_wh_loading.volume{FACT}[DECIMAL(12,2)]
file_status[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.file_status{LABEL}[VARCHAR(10000)]
driver_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.driver_name{LABEL}[VARCHAR(10000)]
upload_date[DATE] -> uploaddate{DATE}[DATE]
file_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.file_name{LABEL}[VARCHAR(10000)]
expedition[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.expedition{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
resi_no[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.resi_no{LABEL}[VARCHAR(10000)]
weight[NUMERIC(12,2)] -> fact.logicnesia_datalake_wh_loading.weight{FACT}[DECIMAL(12,2)]
do_number[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.do_number{LABEL}[VARCHAR(10000)]
pickup_name[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.pickup_name{LABEL}[VARCHAR(10000)]
delivery_date[DATE] -> deliverydate{DATE}[DATE]
drop_name[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_location{REFERENCE}[VARCHAR(10000)]
to_number[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.to_number{LABEL}[VARCHAR(10000)]
uploaded_by[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.uploaded_by{LABEL}[VARCHAR(10000)]
vehicle_license_plate_no[VARCHAR(2147483647)] -> label.logicnesia_datalake_wh_loading.vehicle_license_plate_no{LABEL}[VARCHAR(10000)]
loading_date[DATE] -> loadingdate{DATE}[DATE]
goods_qty[INT4] -> fact.logicnesia_datalake_wh_loading.goods_qty{FACT}[INT]
koli_qty[INT4] -> fact.logicnesia_datalake_wh_loading.koli_qty{FACT}[INT]

Output Stage table/view: logicnesia_dwh_dim_expedition (full, shared) -> Dataset: dataset.logicnesia_dwh_dim_expedition
is_internal[INT2] -> fact.logicnesia_dwh_dim_expedition.is_internal{FACT}[INT]
type[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_expedition.type{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
expedition_code[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_expedition.expedition_code{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]

Output Stage table/view: logicnesia_dwh_dim_goods (full, shared) -> Dataset: dataset.logicnesia_dwh_dim_goods
company[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_goods.company{LABEL}[VARCHAR(10000)]
unit_price[INT4] -> fact.logicnesia_dwh_dim_goods.unit_price{FACT}[INT]
category[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_goods.category{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.logicnesia_dwh_dim_goods.id{LABEL}[INT]
goods_description[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_goods.goods_description{LABEL}[VARCHAR(10000)]
brand[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_goods.brand{LABEL}[VARCHAR(10000)]
goods_id[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_goods.goodsid{LABEL}[VARCHAR(128)]

Output Stage table/view: logicnesia_dwh_dim_location (full, shared) -> Dataset: dataset.logicnesia_dwh_dim_location
channel_area[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.channel_area{LABEL}[VARCHAR(10000)]
outlet_group[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.outlet_group{LABEL}[VARCHAR(10000)]
code[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.code{LABEL}[VARCHAR(10000)]
outlet_region[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.outlet_region{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
channel_type[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.channel_type{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
outlet_city[VARCHAR(2147483647)] -> label.logicnesia_dwh_dim_location.outlet_city{LABEL}[VARCHAR(10000)]

Output Stage table/view: logicnesia_dwh_fact_delivery (full, shared) -> Dataset: dataset.logicnesia_dwh_fact_delivery
total_weight_in_kg[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery.total_weight_in_kg{FACT}[DECIMAL(12,2)]
batch_no[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.batch_no{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
loading_date[DATE] -> loadingdate{DATE}[DATE]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
id[BIGSERIAL] -> label.logicnesia_dwh_fact_delivery.id{LABEL}[INT]
delivery_status[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.delivery_status{LABEL}[VARCHAR(10000)]
total_cost[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery.total_cost{FACT}[DECIMAL(12,2)]
delivered_date[DATE] -> delivereddate{DATE}[DATE]
expedition[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.expedition{LABEL}[VARCHAR(10000)]
total_delivery_goods_qty[INT4] -> fact.logicnesia_dwh_fact_delivery.total_delivery_goods_qty{FACT}[INT]
reconciled_by[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.reconciled_by{LABEL}[VARCHAR(10000)]
total_do_goods_value[INT8] -> fact.logicnesia_dwh_fact_delivery.total_do_goods_value{FACT}[INT]
total_koli_qty[INT4] -> fact.logicnesia_dwh_fact_delivery.total_koli_qty{FACT}[INT]
eta_date[DATE] -> etadate{DATE}[DATE]
total_do_goods_qty[INT4] -> fact.logicnesia_dwh_fact_delivery.total_do_goods_qty{FACT}[INT]
driver_name[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.driver_name{LABEL}[VARCHAR(10000)]
completed_date[DATE] -> completeddate{DATE}[DATE]
delivery_date[DATE] -> deliverydate{DATE}[DATE]
vehicle_license_plate_no[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery.vehicle_license_plate_no{LABEL}[VARCHAR(10000)]
total_volume_in_cbm[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery.total_volume_in_cbm{FACT}[DECIMAL(12,2)]

Output Stage table/view: logicnesia_dwh_fact_delivery_external (full, shared) -> Dataset: dataset.logicnesia_dwh_fact_delivery_external
reconcile_by[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.reconcile_by{LABEL}[VARCHAR(10000)]
total_do_goods_qty[INT4] -> fact.logicnesia_dwh_fact_delivery_external.total_do_goods_qty{FACT}[INT]
raw_weight_in_kg[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.raw_weight_in_kg{FACT}[DECIMAL(12,2)]
total_estimated_cost[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.total_estimated_cost{FACT}[DECIMAL(12,2)]
vehicle_type[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.vehicle_type{LABEL}[VARCHAR(10000)]
rounded_weight_in_kg[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.rounded_weight_in_kg{FACT}[DECIMAL(12,2)]
resi_no[VARCHAR(255)] -> label.logicnesia_dwh_fact_delivery_external.resi_no{LABEL}[VARCHAR(255)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
delivery_status[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.delivery_status{LABEL}[VARCHAR(10000)]
expedition[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.expedition{LABEL}[VARCHAR(10000)]
total_koli_qty[INT4] -> fact.logicnesia_dwh_fact_delivery_external.total_koli_qty{FACT}[INT]
batch_no[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.batch_no{LABEL}[VARCHAR(10000)]
total_delivery_goods_qty[INT4] -> fact.logicnesia_dwh_fact_delivery_external.total_delivery_goods_qty{FACT}[INT]
completed_date[TIMESTAMP] -> completeddate{DATE}[DATE]
rate_calculation_type[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.rate_calculation_type{LABEL}[VARCHAR(10000)]
rounded_volume_in_cbm[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.rounded_volume_in_cbm{FACT}[DECIMAL(12,2)]
raw_volume_in_cbm[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.raw_volume_in_cbm{FACT}[DECIMAL(12,2)]
total_do_goods_value[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_delivery_external.total_do_goods_value{FACT}[DECIMAL(12,2)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
id[BIGSERIAL] -> label.logicnesia_dwh_fact_delivery_external.id{LABEL}[INT]
invoice_number[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_delivery_external.invoice_number{LABEL}[VARCHAR(10000)]

Output Stage table/view: logicnesia_dwh_fact_order (full, shared) -> Dataset: dataset.logicnesia_dwh_fact_order
batch_no[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_fact_delivery{REFERENCE}[VARCHAR(10000)]
koli_qty[INT4] -> fact.logicnesia_dwh_fact_order.koli_qty{FACT}[INT]
resi_no[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_fact_delivery_external{REFERENCE}[VARCHAR(255)]
to_release_date[DATE] -> toreleasedate{DATE}[DATE]
vehicle_license_plate_no[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.vehicle_license_plate_no{LABEL}[VARCHAR(10000)]
weight_in_kg[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_order.weight_in_kg{FACT}[DECIMAL(12,2)]
estimated_cost[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_order.estimated_cost{FACT}[DECIMAL(12,2)]
to_status[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.to_status{LABEL}[VARCHAR(10000)]
approved_by[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.approved_by{LABEL}[VARCHAR(10000)]
priority_delivery[INT4] -> label.logicnesia_dwh_fact_order.prioritydelivery1{LABEL}[VARCHAR(128)]
delivered_date[DATE] -> delivereddate{DATE}[DATE]
expedition[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.expedition{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.logicnesia_dwh_fact_order.id{LABEL}[INT]
login_id[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.login_id{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
driver_name[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.driver_name{LABEL}[VARCHAR(10000)]
total_do_goods_qty[INT4] -> fact.logicnesia_dwh_fact_order.total_do_goods_qty{FACT}[INT]
reassign_count[INT4] -> fact.logicnesia_dwh_fact_order.reassign_count{FACT}[INT]
delivery_status[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.delivery_status{LABEL}[VARCHAR(10000)]
drop_name[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_location{REFERENCE}[VARCHAR(10000)]
total_to_goods_value[INT8] -> fact.logicnesia_dwh_fact_order.total_to_goods_value{FACT}[INT]
external_doc_no[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.external_doc_no{LABEL}[VARCHAR(10000)]
to_number[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.to_number{LABEL}[VARCHAR(10000)]
vehicle_type[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.vehicle_type{LABEL}[VARCHAR(10000)]
total_do_goods_value[INT8] -> fact.logicnesia_dwh_fact_order.total_do_goods_value{FACT}[INT]
last_location_city[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.last_location_city{LABEL}[VARCHAR(10000)]
do_status[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.do_status{LABEL}[VARCHAR(10000)]
delivery_date[DATE] -> deliverydate{DATE}[DATE]
pickup_name[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.pickup_name{LABEL}[VARCHAR(10000)]
received_by[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.received_by{LABEL}[VARCHAR(10000)]
total_delivery_goods_qty[INT4] -> fact.logicnesia_dwh_fact_order.total_delivery_goods_qty{FACT}[INT]
volume_in_cbm[NUMERIC(12,2)] -> fact.logicnesia_dwh_fact_order.volume_in_cbm{FACT}[DECIMAL(12,2)]
completed_date[DATE] -> completeddate{DATE}[DATE]
do_number[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.do_number{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
do_posted_date[DATE] -> doposteddate{DATE}[DATE]
reason[VARCHAR(2147483647)] -> label.logicnesia_dwh_fact_order.reason{LABEL}[VARCHAR(10000)]
loading_date[DATE] -> loadingdate{DATE}[DATE]
priority_delivery_date[DATE] -> prioritydeliverydate{DATE}[DATE]
total_to_goods_qty[INT4] -> fact.logicnesia_dwh_fact_order.total_to_goods_qty{FACT}[INT]
rates_calculation_type[VARCHAR(2147483647)] -> fact.logicnesia_dwh_fact_order.rates_calculation_type{FACT}[INT]
eta_date[DATE] -> etadate{DATE}[DATE]

Output Stage table/view: logicnesia_dwh_fact_order_goods (full, shared) -> Dataset: dataset.logicnesia_dwh_fact_order_goods
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
do_number[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_fact_order{REFERENCE}[VARCHAR(10000)]
goods_qty[INT4] -> fact.logicnesia_dwh_fact_order_goods.goods_qty{FACT}[INT]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
id[BIGSERIAL] -> label.logicnesia_dwh_fact_order_goods.id{LABEL}[VARCHAR(128)]
goods_id[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_goods{REFERENCE}[VARCHAR(128)]

Output Stage table/view: logicnesia_mst_lead_time_calculation_type (full, shared) -> Dataset: dataset.logicnesia_mst_lead_time_calculation_type
calculation_type[VARCHAR(2147483647)] -> label.logicnesia_mst_lead_time_calculation_type.calculation_type{LABEL}[VARCHAR(10000)]
id[SERIAL] -> label.logicnesia_mst_lead_time_calculation_type.id{LABEL}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]

Output Stage table/view: logicnesia_mst_rate_calculation_type (full, shared) -> Dataset: dataset.logicnesia_mst_rate_calculation_type
calculation_type[VARCHAR(2147483647)] -> label.logicnesia_mst_rate_calculation_type.calculation_type{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
id[SERIAL] -> label.logicnesia_mst_rate_calculation_type.id{LABEL}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]

Output Stage table/view: logicnesia_mst_vehicle_type (full, shared) -> Dataset: dataset.logicnesia_mst_vehicle_type
vehicle_type[VARCHAR(2147483647)] -> label.logicnesia_mst_vehicle_type.vehicle_type{LABEL}[VARCHAR(10000)]
id[INT8] -> label.logicnesia_mst_vehicle_type.id{LABEL}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]

Output Stage table/view: logicnesia_trx_vendor_tracking (full, shared) -> Dataset: dataset.logicnesia_trx_vendor_tracking
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
id[BIGSERIAL] -> label.logicnesia_trx_vendor_tracking.id{LABEL}[INT]
created_by[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.created_by{LABEL}[VARCHAR(10000)]
expedition[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.expedition{LABEL}[VARCHAR(10000)]
delivered_date[DATE] -> delivereddate{DATE}[DATE]
received_by[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.received_by{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
batch_no[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.batch_no{LABEL}[VARCHAR(10000)]
file_name[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.file_name{LABEL}[VARCHAR(10000)]
updated_by[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.updated_by{LABEL}[VARCHAR(10000)]
last_location_city[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.last_location_city{LABEL}[VARCHAR(10000)]
do_number[VARCHAR(2147483647)] -> label.logicnesia_trx_vendor_tracking.do_number{LABEL}[VARCHAR(10000)]
resi_no[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_fact_delivery_external{REFERENCE}[VARCHAR(255)]
is_active[INT2] -> fact.logicnesia_trx_vendor_tracking.is_active{FACT}[INT]

Output Stage table/view: v_logicnesia_dwh_aging_order (full, shared) -> Dataset: dataset.v_logicnesia_dwh_aging_order
to_number[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.tonumber{LABEL}[VARCHAR(128)]
delivery_aging_days[INT4] -> fact.v_logicnesia_dwh_aging_order.delivery_aging_days{FACT}[INT]
to_aging_days[INT4] -> fact.v_logicnesia_dwh_aging_order.to_aging_days{FACT}[INT]
drop_name[VARCHAR(2147483647)] -> dataset.logicnesia_dwh_dim_location{REFERENCE}[VARCHAR(10000)]
delivered_date[DATE] -> delivereddate{DATE}[DATE]
vehicle_license_plate_no[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.vehicle_license_plate_no{LABEL}[VARCHAR(10000)]
to_release_date[DATE] -> toreleasedate{DATE}[DATE]
pickup_name[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.pickup_name{LABEL}[VARCHAR(10000)]
do_posted_date[DATE] -> doposteddate{DATE}[DATE]
expedition[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.expedition{LABEL}[VARCHAR(10000)]
total_delivery_goods_qty[INT4] -> fact.v_logicnesia_dwh_aging_order.total_delivery_goods_qty{FACT}[INT]
do_aging_days[INT4] -> fact.v_logicnesia_dwh_aging_order.do_aging_days{FACT}[INT]
delivery_status[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.delivery_status{LABEL}[VARCHAR(10000)]
total_to_goods_qty[INT4] -> fact.v_logicnesia_dwh_aging_order.total_to_goods_qty{FACT}[INT]
delivery_date[DATE] -> deliverydate{DATE}[DATE]
total_do_goods_qty[INT4] -> fact.v_logicnesia_dwh_aging_order.total_do_goods_qty{FACT}[INT]
do_number[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_aging_order.do_number{LABEL}[VARCHAR(10000)]

Output Stage table/view: v_logicnesia_dwh_order_difot (full, shared) -> Dataset: dataset.v_logicnesia_dwh_order_difot
do_processed_lead_time[INT4] -> fact.v_logicnesia_dwh_order_difot.do_processed_lead_time{FACT}[INT]
to_number[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_order_difot.tonumber{LABEL}[VARCHAR(128)]
total_to_goods_qty[INT4] -> fact.v_logicnesia_dwh_order_difot.total_to_goods_qty{FACT}[INT]
to_release_date[DATE] -> toreleasedate{DATE}[DATE]
do_number[VARCHAR(2147483647)] -> label.v_logicnesia_dwh_order_difot.do_number{LABEL}[VARCHAR(10000)]
do_posted_date[DATE] -> doposteddate{DATE}[DATE]
total_do_goods_qty[INT4] -> fact.v_logicnesia_dwh_order_difot.total_do_goods_qty{FACT}[INT]

====================== End of Output Stage -> LDM mapping ======================


2022-01-20T04:06:23.711+0100 [INFO]: 

====================== Data distribution scope ======================


2022-01-20T04:06:23.711+0100 [INFO]: Project="simrghe7qxg52yaovq1jfuo5g5tbd1b6"; datasets=[{dataset.logicnesia_dwh_dim_goods, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_mst_rate_calculation_type, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_fact_delivery_external, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_fact_delivery, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_fact_order, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_trx_vendor_tracking, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_datalake_wh_loading, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_mst_lead_time_calculation_type, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_mst_vehicle_type, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_datalake_shipment_entry, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_datalake_do_process, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_dim_expedition, full, loadDataFrom=1970-01-01T00:00}, {dataset.v_logicnesia_dwh_aging_order, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_dim_location, full, loadDataFrom=1970-01-01T00:00}, {dataset.logicnesia_dwh_fact_order_goods, full, loadDataFrom=1970-01-01T00:00}, {dataset.v_logicnesia_dwh_order_difot, full, loadDataFrom=1970-01-01T00:00}]
2022-01-20T04:06:23.711+0100 [INFO]: 

====================== End of Data distribution scope ======================


2022-01-20T04:06:23.711+0100 [INFO]: 

====================== Downloading and integrating data ======================


2022-01-20T04:14:28.763+0100 [INFO]: Data for project="simrghe7qxg52yaovq1jfuo5g5tbd1b6" was downloaded. Datasets: [{dataset.logicnesia_datalake_do_process, upsert, rows=78640, size=14766089 bytes}, {dataset.logicnesia_datalake_shipment_entry, upsert, rows=150511, size=31073946 bytes}, {dataset.logicnesia_datalake_wh_loading, upsert, rows=4136, size=782342 bytes}, {dataset.logicnesia_dwh_dim_expedition, upsert, rows=27, size=1109 bytes}, {dataset.logicnesia_dwh_dim_goods, upsert, rows=52860, size=3351477 bytes}, {dataset.logicnesia_dwh_dim_location, upsert, rows=645, size=55035 bytes}, {dataset.logicnesia_dwh_fact_delivery, upsert, rows=126, size=18965 bytes}, {dataset.logicnesia_dwh_fact_delivery_external, upsert, rows=442, size=54841 bytes}, {dataset.logicnesia_dwh_fact_order, upsert, rows=9416, size=2265252 bytes}, {dataset.logicnesia_dwh_fact_order_goods, upsert, rows=287938, size=23269462 bytes}, {dataset.logicnesia_mst_lead_time_calculation_type, upsert, rows=2, size=61 bytes}, {dataset.logicnesia_mst_rate_calculation_type, upsert, rows=4, size=97 bytes}, {dataset.logicnesia_mst_vehicle_type, upsert, rows=2, size=54 bytes}, {dataset.logicnesia_trx_vendor_tracking, upsert, rows=4, size=620 bytes}, {dataset.v_logicnesia_dwh_aging_order, upsert, rows=9416, size=1040048 bytes}, {dataset.v_logicnesia_dwh_order_difot, upsert, rows=9416, size=576821 bytes}]
2022-01-20T04:14:48.787+0100 [WARN]: Project "simrghe7qxg52yaovq1jfuo5g5tbd1b6" was not integrated. Reason: Upload to dataset dataset.logicnesia_dwh_fact_order failed with 'An error occured during loading of csv files: SQLSTATE_NUMERIC_VALUE_OUT_OF_RANGE. Details: value "2974380000" is out of range for type integer: 2974380000'.
2022-01-20T04:14:58.791+0100 [INFO]: 

====================== End of downloading and integrating data ======================


2022-01-20T04:14:58.794+0100 [ERROR]: Data distribution worker failed. Reason: All projects failed to load.