Skip to Main Content

FDMEE Data load taking too long

User_W7KT0Mar 7 2018 — edited Apr 23 2018

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.

Comments