Thursday, June 16, 2005
HITS INT process
Had an issue yesterday. Went in and checked. Found nothing wrong. So I went ahead and update the load_status table for INT_BASE enry to 5. All went well that night.
Today, HRWorld is complaining about INT file is updated the day before, not yesterday. Checked with Tonya, found out that I need to set the agg_source table as well.
No actually, I don't need to change the agg_source table. What I need to do is to set the load_step to 5 for that source, and change the comments field to "Completed ..." or "Proceseed ...", because the function that populates the agg_source table looks for:
select max(t.load_date) from LOAD_STATUS t where t.load_step = '5'
and t.object_code = rtrim(s.source)||'_BASE'
and (comments like 'Processed%' or comments like 'Completed%'
Today, HRWorld is complaining about INT file is updated the day before, not yesterday. Checked with Tonya, found out that I need to set the agg_source table as well.
No actually, I don't need to change the agg_source table. What I need to do is to set the load_step to 5 for that source, and change the comments field to "Completed ..." or "Proceseed ...", because the function that populates the agg_source table looks for:
select max(t.load_date) from LOAD_STATUS t where t.load_step = '5'
and t.object_code = rtrim(s.source)||'_BASE'
and (comments like 'Processed%' or comments like 'Completed%'
# posted by Ryan : 11:13 AM
