While performing incremental reading using mapping variable using setvariable how can i increment date value ,can u explain in detail,which function i have to use ?
> Generally Incremental reading will be done using Dates comparisions.
src_date_field > $$Mapping_var_date ... etc.. to load only recent records.. etc..
> Our sample senario is ... Wee need to extract the records .. ' whose update/insert date is to be 3 days before from Todays date '..
so i have set the mapping variable as...
- here $$Date_To_Extract is Mapping Variable...