GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center