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 set sal=sal+1000;
   14 rows updated.
   
   SQL> commit;
   Commit complete.

3. Check the Extract process statistics:

   GGSCI (prim1-ol6-112.localdomain) 3> stats EGGTEST1 hourly
   
   Sending STATS request to...