We have a job which we need to run on daily bases, before loading data in a table we need to validate whether the input file is received or not.
Daily client will place the files in a particular path.Below files which I need to process for 04/01/2013(Load date).
src_sps_d_Call_Center_Reporting_20130329(yyyymmdd) _01.dat
src_sps_d_Call_Center_Trancation _20130329(yyyymmdd )_01.dat
src_sps_d_Payment_transaction _Reporting_20130329(yyyymmdd )01.dat
src_sps_d_Call_Loan Reporting_20130329(yyyymmdd )_01.dat
I have one ss_calendar file which contains whether load date will contain file or not.
Servicer ,Load date, file will come or not
SPS, 3/29/20013,N
SPS , 4/1/2013, Y
Ocwn, 3/29/2013,N
Ocwn,4/1/2013, N
And I have another file ss_Load_Proc which contains information about which load day should contain which file.
Servicer , Load day, inputfiles
SPS , Tuesday,Monday and Friday
SPS ,Wednesday Tuesday
SPS, Thursday , Wednesday
SPS , Friday,Thursday
OCWN , Monday , Monday
Suppose if I am loading data for 04/01/2013 date ,first from SS_Calendar I want to check whether for SPS servicer will file come or not.If the indicator in Y then in ss_Load_Proc file I should check whether days in inputfiles column and DD in Input file are same or not.If day matches then I shouid touch one file.If file is missing then I should drop email to team and update the name(date) in Missing.TXt file.
Please tell the procedure to write shell script.