Use of token in ogg

OGG edition ：19.1

RDBMS：19.15 

Test purpose ：
Source side table ：bb.t2 
Destination end table ： zbb.t4,zbb.t5 .  t4 and t5 Different structure .t5 In contrast to t4 The redundant columns in are token Get the environment variable
At the same time bb.t2 Synchronize to zbb.t4 and zbb.t5 .

About token and @getenv function , Please refer to the official documents Oracle GoldenGate Windows and UNIX Reference Guide 

Source side table ：

[email protected]>desc t2
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID						    NUMBER
 NAME						    VARCHAR2(10)

[email protected]>

Destination end table

conn zbb/oracle
create table t5 (
no number,
firstname varchar2(10),            ## token name  = token value 
host varchar2(40),          --     TKN-HOST = @GETENV ('GGENVIRONMENT", "HOSTNAME'),
gg_group varchar2(40),      --     TKN-GRP = @GETENV ('GGENVIRONMENT", "GROUPNAME'),
osuser varchar2(40),        --     TKN-USER = @GETENV ('GGENVIRONMENT", "OSUSERNAME'),
domain varchar2(40),        --     TKN-DOMAIN = @GETENV ('GGENVIRONMENT", "DOMAINNAME'),
UPDATETIME  date,           --     updatetime= @TOKEN ('GGHEADER','COMMITTIMESTAMP'),
tablename varchar2(40),     --     TKN-TBNAME = @GETENV ('GGHEADER”, “TABLENAME'),
optype varchar2(40)         --     TKN-OPT = @GETENV ('GGHEADER”, “OPTYPE'),
)

Source side ext2 , Source end ext process , Get more environment variables , Although for t4 surface , It won't take so much , But for t5 surface , You can use these . No effect t2 and t4,t2 and t5 Simultaneous synchronization of

table bb.t2 ,TOKENS  &      ##  I can't write in one line , You can use symbols & Line break  
(TKN-HOST = @GETENV ('GGENVIRONMENT', 'HOSTNAME'), &
TKN-GRP = @GETENV ('GGENVIRONMENT', 'GROUPNAME'), &
TKN-USER = @GETENV ('GGENVIRONMENT', 'OSUSERNAME'),&
TKN-DOMAIN = @GETENV ('GGENVIRONMENT', 'DOMAINNAME'),&
updatetime= @GETENV ('GGHEADER','COMMITTIMESTAMP'),&
TKN-TBNAME = @GETENV ('GGHEADER', 'TABLENAME'),&
TKN-OPT = @GETENV ('GGHEADER', 'OPTYPE'));    

Source side pump2 process

table bb.t2 ,TOKENS    &
(TKN-HOST = @GETENV ('GGENVIRONMENT', 'HOSTNAME'), &
TKN-GRP = @GETENV ('GGENVIRONMENT', 'GROUPNAME'), &
TKN-USER = @GETENV ('GGENVIRONMENT', 'OSUSERNAME'),&
TKN-DOMAIN = @GETENV ('GGENVIRONMENT', 'DOMAINNAME'),&
updatetime= @GETENV ('GGHEADER','COMMITTIMESTAMP'),&
TKN-TBNAME = @GETENV ('GGHEADER', 'TABLENAME'),&
TKN-OPT = @GETENV ('GGHEADER', 'OPTYPE'));

Because the table on the source side has not changed , So don't generate again defgen file, Just on the target side rep2 Add map , The original is right t4 Tabular map, Also exist  

map bb.t2,target zbb.t4, COLMAP (USEDEFAULTS,no=id,firstname=name ,updatetime= @TOKEN ('updatetime')),filter (id > 30); --  Just copy id>30

map bb.t2,target zbb.t5, COLMAP ( &
USEDEFAULTS, &
no=id, &
firstname=name , &
host = @token ('TKN-HOST'), &
gg_group = @token ('TKN-GRP'),  &
osuser= @token ('TKN-USER'),  &
domain = @token('TKN-DOMAIN'),&
updatetime= @TOKEN ('updatetime'),  &
tablename= @TOKEN ('TKN-TBNAME'), &
optype= @TOKEN ('TKN-OPT'), &
);

Synchronous success , The original T4, You can also synchronize . T2 Synchronize to T4,T5  .

[email protected]>select * from t4;

	NO FIRSTNAME  UPDATETIME
---------- ---------- -------------------------
	41 p	      2022-07-13 16:56:21
	42 ae	      2022-07-13 17:10:37
	43 iwc	      2022-07-13 17:13:22
	47 mmm                                       ##  There is no result here , Because map t2 To t4 Of ,token in ,token The name is misspelled  , After modification .
	48 ccc	      2022-07-14 15:24:15
	14 c	      2022-07-11 14:32:28
	15 d	      2022-07-11 14:34:23
	11 c	      2022-07-09 19:14:23
	13 c	      2022-07-09 19:28:29
	18 a	      2022-07-13 15:37:43
	19 m	      2022-07-13 15:41:25

	NO FIRSTNAME  UPDATETIME
---------- ---------- -------------------------
	32 c	      2022-07-13 16:01:14
	40 i	      2022-07-13 16:04:13
	41 m	      2022-07-13 16:53:05
	 9 a	      2022-07-08 14:33:03
	10 aa	      2022-07-08 17:13:07
	17 a	      2022-07-13 11:24:54
	16 a	      2022-07-13 10:35:12

18 rows selected.

[email protected]>select * from t5;         ## DOmain Field has no result , This field is only for Windows, There are instructions on the official documents  

	NO FIRSTNAME  HOST	       GG_GROUP   OSUSER     DOMAIN	UPDATETIME		  TABLENAME  OPTYPE
---------- ---------- ---------------- ---------- ---------- ---------- ------------------------- ---------- ----------
	44 aa	      redhat762100     PUMP2	  oracle					  BB.T2      INSERT
	45 mw	      redhat762100     PUMP2	  oracle					  BB.T2      INSERT
	46 afdsa      redhat762100     PUMP2	  oracle		2022-07-14 15:14:32	  BB.T2      INSERT
	47 mmm	      redhat762100     PUMP2	  oracle		2022-07-14 15:22:35	  BB.T2      INSERT
	48 ccc	      redhat762100     PUMP2	  oracle		2022-07-14 15:24:15	  BB.T2      INSERT

[email protected]>

END