Hi All,
We are loading 2 months (Jan and Feb) of data from Teradata .
No of rows: 387939
No of rows for Jan: 189295
No of rows for Feb: 198644
It suppose to be completed by 10 mins . But,dataload is taking 5+ Hrs.
If we restart the service and trigger again it takes 10 mins,but next run takes 5+ hrs again.
Attached log helps to identify which one is taking more time.
Usual Run:
Processing Mappings for Column 'UD1'
2018-03-05 11:08:15,747 INFO [AIF]: Data Rows Updated by Location Mapping '99_All_Maps' (LIKE): 189242
2018-03-05 11:08:15,749 INFO [AIF]:
Processing Mappings for Column 'UD10'
2018-03-05 11:08:15,854 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0
2018-03-05 11:08:15,854 INFO [AIF]:
Processing Mappings for Column 'UD3'
2018-03-05 11:08:15,941 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0
2018-03-05 11:08:15,941 INFO [AIF]:
Long run:
Processing Mappings for Column 'UD1'
2018-03-06 19:20:02,136 INFO [AIF]: Data Rows Updated by Location Mapping '99_All_Maps' (LIKE): 189284
2018-03-06 19:20:02,138 INFO [AIF]:
Processing Mappings for Column 'UD10'
2018-03-06 22:20:22,516 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0
2018-03-06 22:20:22,735 INFO [AIF]:
Processing Mappings for Column 'UD3'
2018-03-06 22:20:22,838 INFO [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0
2018-03-06 22:20:22,838 INFO [AIF]:
Please help to fix the issue.