see this is what i hav...
in the database:
table one: Customer(ID, Name, Age, Location_ID)
table 2: Location(ID, LOC_NAME)
in a datawarehouse:
table 1: Cust(ID, Name, Age, Location_Name)
now i want to refresh the dataware house without deleting all the data in it... just adding extra rows that are either new or edited and removing those rows that have been edited...
NOW the problem is in the 2nd part where i want to delete those rows that have been edited..