Goldengate with conditional parameters.
844166Mar 18 2011 — edited Apr 2 2011Hi all,
I have one table source side which is need to be replicat on target side.
I want a conditional replicatio on this.
The situation is
==========
Target Side:
* one table TABLE_NEED having column NAME,FREQUENCY
Source Side:
* one table TABLE_NEED having coumn NAME,FREQUENCY,USED_BY
==========
Now I want conditional replication on the target side on column USED_BY
The value for this column (USED_BY) is dependent on the value of FREQUENCY column.
If FREQUENCY column is NULL then the value of the USED_BY is replicated to a value of NAME
and if FREQUENCY column is ANY VALUE then the value of the USED_BY is replicated to a value of FREQUENCY
Note: Other two columns NAME,FREQUENCY is just a simple replication. Only ti differs to the USED_BY column at target side.
WE CAN GO FOR THE TRIGGERS/PROCEDURES ON THE TARGET SIDE FOR THIS KIND OF UPDATES BUT THE REQUIREMENT IS TO GET THIS UPDATES ONLY THROUGH THE GOLDENGATE.
please please help me on this question.