Goldengate with conditional parameters.

844166

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.

stevencallan

If you are using 11g, you can use a virtual column and not even bother with GoldenGate. Within GoldenGate, use a column mapping with nvl or use a searched case. Frequency and name are the same datatype? Further, why store used_by in the first place? Its value is functionally dependent on other columns, so in terms of normalization, it is lacking.

844166

ok it should with the parameter using getupdates getdelete getinsert. these parameter can b use as conditional parameters. I got my help. You can also refer this one....

844166

answerd by my-self only.

No further action required.