Performing an Initial load with Oracle GoldenGate 12c We care for your speed. Below is an easy way to Performing an Initial load with Oracle GoldenGate 12c. What is GoldenGate Initial Load ? Loads the data directly from source tables to target tables. Change synchronization vs Initial… Read More
Mapping Columns on Oracle GoldenGate 12c We care for your speed. Below is an easy way to Mapping Columns on Oracle GoldenGate 12c Oracle GoldenGate provides for column mapping at the table level and at the global level. Default column mapping is also provided in the absence… Read More
IgnoreDelete and IgnoreUpdate parameters in Oracle GoldenGate This article covers Oracle GoldenGate IgnoreDelete and IgnoreUpdate parameters for Oracle GoldenGate IGNOREUPDATES Parameter IGNOREDELETES Parameter NOTE : The parameters used in this article could be used either in Extract,Data pump or Replicat parameter file. As a task… Read More
Installation of PostgreSQL 11.4 in Linux Platform. Installation of PostgreSQL in Linux We love to make it easy for you. Follow the steps below and you are done. STEP 1 : As a first step, we need to download the PostgreSQL by using the below link.… Read More
How to Download and Install the pgAdmin 4 In this article , we will see download and installation of pgAdmin4. STEP 1 : Download the pgAdmin 4 by using the below link. https://www.pgadmin.org/ Choose the Download Button. Choose the windows option. Select the option which… Read More
Installation of PostgreSQL 11.4 On Windows Platform In this article , we will see how to download and install PostgreSQL 11.4 on Windows platform. STEP 1 : As a first step we need to download the PostgreSQL by using the below link. https://www.postgresql.org/ Click on… Read More
Oracle to MySQL Heterogeneous Unidirectional Replication In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and MySQL. Source : Oracle DB Target : MySQL Download Goldengate Binaries Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you are using… Read More
ORACLE GOLDENGATE SUBDIRECTORIES In this article we will see the sub-directories of Oracle GoldenGate we have totally 11 subdirs available in Oracle GoldenGate. List of directories : dirdat –> Extract data files dirchk –> Checkpoint file dirtmp –> Temporary files dirrpt –> Report file dirdef… Read More
COLS & COLSEXCEPT FILTER In Goldengate In this article we will see how to replicate only particular columns to the target table On Source database : Take Dept table and add two more columns SQL> select * from dept; DEPTNO DNAME LOC ———- ————– ————-… Read More
MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log In this article we will see MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log First setup Master -slave replication between two mysql servers. Use below link to setup Master-slave Replication MySQL… Read More
