Delete and Update Records without using SCD, Update strategy in Informatica

Please help me to solve this:

I am having Flat file which stores data of 3 locations ( Ahmedabad, Bangalore & Chennai ). I am loading this data to Database. Insert is simple. But when I am changing my location in source i.e., ( Bangalore to Chennai, Ahmedabad or vice versa) it should insert/update the new record and delete from previous table.

Example:

Location

Bangalore ---> Chennai (Updated location) Chennai Ahmedabad

After Informatica transformation:

Location Chennai Chennai Ahmedabad