how to do complex validation on huge volume of records before inserting into table..please see the explained scenario and suggest ideas

Hey thanks for the answer! Was really looking for it. :)