As the data of the clients that are only of Orange and Los Angeles counties should be loaded into the database, a reference file is needed in order to filter only Orange and Los Angeles clients. The file contains the following city-to-county mappings.
GRANADA HILLS;Los Angeles
MISSION HILLS;Los Angeles
The reference file in this Job is named LosAngelesandOrangeCounties.txt.