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
CAclubindia
