1. Read the input file. Input file have a 10 millions of records.
2. Search each input record into database(Employee Table and Departnment table) by using the Key Employee Location and Departnment number.
Employee location is in Employee Table.
Departnment Number is Department Table.
If records are found fetch all the records from Employee table and Department table by using the filed Employee location and Department Number and write into a output file.
3. Produce the control report input record count and output file record count.