On 7/11/2014 1:04 AM, madhav bahuguna wrote: > How do i make delta import detect deleted values. > I do have a timestamp column to detect changes ,but the requirement is such > that rows will be deleted from the table.Every time i run delta import the > index still shows the deleted value. > How do i make delta import detect deleted values so that it does not show > deleted values.
As Ahmet indicated, you must have a way to detect that deletions have happened. Marking rows as deleted with an active/inactive field is one way. Another way (the way that we use) is to have a delete trigger on the table that creates an entry in a delete tracking table. Either way, your indexing process will need customization to deal with this additional information. Thanks, Shawn
