GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

how to extract a particular column only when it is updated

edited Jun 20, 2017 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hello,

I need to know if there is a way to extract only a particular column of a sqlmp table in HP Nonstop guardian.

My source table is CSTEST and target table is BSTEST

CSTEST Table structure as below

CARDNUM                        VARCHAR(19) NO DEFAULT NOT NULL      

PVD                            CHAR(10) DEFAULT NULL                

NAME                           CHAR(15) DEFAULT NULL                

ADDR                           CHAR(30) DEFAULT NULL                

                                                                   

Target table BSTEST structure as below

CARDNUM                        VARCHAR(19) NO DEFAULT NOT NULL

PVD                            CHAR(10) DEFAULT NULL          

NAME                           CHAR(15) DEFAULT NULL          

                                                              

Column CARDNUM is Primary key.

I only need to capture PVD column only when it is updated on source. Also please note that my extractor is datapmp and reads audit trail of Hp nonstop system.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center