Skip to Main Content
Forums

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Source always wins

784624Sep 25 2010 — edited Oct 19 2010
Hi

We are doing the initial load through a utility and we are not sure we have all data from the source.

We want to have the following rule when the change capture happens.


1) Update of a record when the primary keys are not present in the target database -> Convert the update statment to INsert statment(Need to have all the columns)

2) Delete a record when the primary keys are not present in the target - Ignore the statement.

3) Insert of a record when the primary keys are present in the target. Overlay the records (Need to touch all columns in the target)

Handlecollisions parameter will overlay the existing records but ignores the update when the keys are not present in the target.

Appreciate your suggestions.

Thanks

Comments

843834
Did you include your parser jar file in the archive tag? Thats required.

<applet code="Some.class" archive="some.jar, parser.jar" width=100 height=200></applet>
843834
Thank you very much Sir. Please inform me of the methods involved in assigning duke-dollars so i can give you some.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 16 2010
Added on Sep 25 2010
#goldengate
3 comments
401 views