Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.9 kB
3
Indexable
actually logic is correctly only i guess but its behaving abnorammly for first two tables which has more data if you see Count for apad_matrix is 266112 but only 50000 inserted and also Count for cobp_pass_matrix: 362264 but only 150000 inserted remaining tables are fine only

12:41:21|INFO|main|122|Count etl_ppm_replication_master: 9
12:41:21|INFO|main|134|-- ++++++++++++++++++++++++++++++++ Seq# 1| entity# 10000 | PC_EXT | apad_matrix
12:41:21|INFO|main|142|Reading values
12:42:03|INFO|main|145|Count apad_matrix: 266112
12:43:36|INFO|main|165|Insertion 50000 records into apad_matrix | Batch 0 | Total Inserted: 50000
12:43:36|INFO|main|134|-- ++++++++++++++++++++++++++++++++ Seq# 2| entity# 10001 | PC_EXT | cobp_pass_matrix
12:43:36|INFO|main|142|Reading values
12:44:21|INFO|main|145|Count cobp_pass_matrix: 362264
12:45:34|INFO|main|165|Insertion 50000 records into cobp_pass_matrix | Batch 0 | Total Inserted: 50000
12:46:48|INFO|main|165|Insertion 50000 records into cobp_pass_matrix | Batch 1 | Total Inserted: 100000
12:48:00|INFO|main|165|Insertion 50000 records into cobp_pass_matrix | Batch 2 | Total Inserted: 150000
12:48:00|INFO|main|134|-- ++++++++++++++++++++++++++++++++ Seq# 3| entity# 10002 | PC_EXT | device_combo_subsidy
12:48:00|INFO|main|142|Reading values
12:48:02|INFO|main|145|Count device_combo_subsidy: 4784
12:48:10|INFO|main|165|Insertion 4784 records into device_combo_subsidy | Batch 0 | Total Inserted: 4784
12:48:10|INFO|main|134|-- ++++++++++++++++++++++++++++++++ Seq# 4| entity# 10003 | PC_EXT | easyphone_matrix
12:48:10|INFO|main|142|Reading values
12:48:13|INFO|main|145|Count easyphone_matrix: 17712
12:48:44|INFO|main|165|Insertion 17712 records into easyphone_matrix | Batch 0 | Total Inserted: 17712
12:48:44|INFO|main|134|-- ++++++++++++++++++++++++++++++++ Seq# 5| entity# 10004 | PC_EXT | easyphone_upgrade