Usage of GG functions in Golden Gate replicate process
edited Jul 1, 2013 4:32AM in GoldenGate, Streams and Distributed Database (MOSC) 19 commentsAnswered
I want to replicat only those records where abs_date column will consists records less than 2 years only from current date(i.e. now year is 2013 and so i want to fetch the records only till 2011). I am doing something like this, but getting error:
Map XXXX,target XXXX,
colmap(A=A,
B=B)
,WHERE ( abs_date > @DATENOW - 731);
Getting error in report file as: Error in WHERE clause. Column name not found.
Please let me know what can be modified to achieve the result.
Thanks in advance
0