The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We have 2 systems.Care200 and Scala.
data comes from care and is to be imported to scala on a daily basis.around 60 sql scripts are to be run daily to extract data fron care system. currently this data is maualy formated and mapped before it is imported to scala. thus the program to automate the the process of data extraction, mapping and formating.extraction and formatting are straight forward to understand. To explain mapping i will use this e.g. a cashier has a code 933 in care, the same cashier has the code PUM in scala. when the data comes from care2000 all cashiers codes will have to be changed. hence cashier code 933 will be changed to PUM.that is the mapping process. the same same mapping applies to service codes and scheme/Debtors.
1. the first process is for extraction. this process runs SQL scripts and saves output in excel file. the excel files are saved with the same name as the sql script only that the date is concatenated. ie if the script is called IP_CASH_INVOICE....
Sign in or Register to see more