Forum Stats

  • 3,873,344 Users
  • 2,266,537 Discussions
  • 7,911,514 Comments

Discussions

Goldengate with conditional parameters.

844166
844166 Member Posts: 27
edited Apr 2, 2011 5:49PM in GoldenGate
Hi 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.
Tagged:

Answers

This discussion has been closed.