Delete Data from Target Table when Flag sets
I am creating BODS job. here I am going to use TABLE COMPARISON and HISTORY PRESERVING.
My problem is I want to remove older records from Target Table only if Value from one column reach to particular Value or Value get change. And also insert new Records if exist.
Can any one help?