Oracle Ramblings
Tips and wisdom from 15 years of DBA experience
Friday, November 12, 2010
How To Put NULL In Target Column With Golden Gate
Golden Gate has a large API which makes most tasks very simple. One item that took me a bit longer to figure out than it should of was how to tell Golden Gate to place NULL into the target column. Here is how to do it:
MAP source.table, TARGET target.table, COLMAP(USEDEFAULTS, null_column = @COLSTAT(NULL));
I have no idea why it took me so long to figure this out.
1 comment:
San Mateo Attic Insulation
said...
Hi nice reading your bloog
December 9, 2022 at 1:49 AM
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
►
2011
(1)
►
October
(1)
▼
2010
(5)
▼
November
(2)
Transform data in Oracle Golden Gate
How To Put NULL In Target Column With Golden Gate
►
September
(1)
►
February
(2)
►
2009
(17)
►
December
(3)
►
October
(3)
►
September
(5)
►
August
(6)
►
2008
(4)
►
November
(4)
About Me
Craig Glendenning
View my complete profile
1 comment:
Hi nice reading your bloog
Post a Comment