Re: delta import to detect deleted values

2014-07-11 Thread Chris Hostetter
: 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. If you have no c

Re: delta import to detect deleted values

2014-07-11 Thread Shawn Heisey
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 d

Re: delta import to detect deleted values

2014-07-11 Thread Ahmet Arslan
Hi, You need a soft deletion column. Don't delete the entry instead mark it as deleted/inactive etc. Ahmet On Friday, July 11, 2014 10:12 AM, madhav bahuguna wrote: Hi, How do i make delta import detect deleted values. I do have a timestamp column to detect changes ,but the requirement is s

delta import to detect deleted values

2014-07-11 Thread madhav bahuguna
Hi, 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