Does COLMAP continuously update all columns listed?
edited Jul 25, 2013 9:17AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
Hi,
I'm trying to perform a limited amount of data transformation using goldengate. And had a couple of questions.
Here's the basic idea
Source Table foo1 is
Destination Table Foo1 is
Will subsequent updates cause the INSERT_DATE column to update with the current time? If so how can I prevent this from happening? I've looked at FILTER as a possible solution. If that seems right could I see an example of that please?
I'm trying to perform a limited amount of data transformation using goldengate. And had a couple of questions.
Here's the basic idea
Source Table foo1 is
ID
Employee_name
salary
Employee_name
salary
Destination Table Foo1 is
ID
insert_date -- the date the record was replicated over
employeename
salary
reviewed -- a boolean type value
========insert_date -- the date the record was replicated over
employeename
salary
reviewed -- a boolean type value
REPLICAT tgt_DB
...
MAP SOURCE.FOO1, TARGET DEST.FOO1, COLMAP (USEDEFAULTS,
Employee_name= employeename,
Insert_date = @DATENOW(),
reviewed="N");
...
MAP SOURCE.FOO1, TARGET DEST.FOO1, COLMAP (USEDEFAULTS,
Employee_name= employeename,
Insert_date = @DATENOW(),
reviewed="N");
Will subsequent updates cause the INSERT_DATE column to update with the current time? If so how can I prevent this from happening? I've looked at FILTER as a possible solution. If that seems right could I see an example of that please?
0