Wednesday, September 21, 2016

Filter records by Date in GoldenGate Extract or Replicat

I post this information because it was hard for me to find the solution in GoldenGate Documentation.

Scenario: We need to implement a filter by date in the Extract

              where date_column > to_date('2016-01-01','yyyy-mm-dd')

Simple...

Implemented:


TABLE source_table,
COLS (list of columns),
FILTER (@COMPUTE (@DATE('JUL', 'YYYY-MM-DD', date_column) >= @DATE('JUL', 'YYYY-MM-DD', '2016-01-01')) > 0)

Should be easier, if someone found another option please feedback.

No comments:

Post a Comment