Oracle GoldenGate 11g Complete Cookbook

Verifying the data transfer on the target system

This recipe will show you how to verify data transfer on a target system.

Getting ready

For this recipe we will use the continuous replication setup for the SCOTT schema done in Setting up a simple GoldenGate replication configuration between two single node databases earlier in this chapter.

How to do it...

Perform the following steps in the source database:

1. Check the number of employees whose salary is greater than 3000:

   SQL> select * from EMP where sal>3000;
   
   EMPNO  ENAME   JOB     MGR  HIREDATE  SAL  COMM  DEPTNO
   -----  -----    ---      ---  --------  ---  ----  ------
   7839   KING      PRESIDENT   17-NOV-81	 5000         10

2. Perform some updates in the source database. Here we increase the salary for all employees by 1000:

   SQL> update SCOTT.EMP ...