GoldenGate FORMATASCII
Hello professionals:
I read Oracle document: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters065.htm#GWURF497 , and there is an example Example 3,
Example 3
FORMATASCII, NOHDRFIELDS, OP, TS, NONAMES, NOQUOTE
produces the following:
I,CUSTOMER,2011-01-21:14:09:46.421335,Eric,San Fran,550,
V,CUSTOMER,2011-01-21:14:09:46.421335,Eric,,100,
But when I tried it by myself using FORMATASCII, NOHDRFIELDS, OP, TS, NONAMES, NOQUOTE ,I only can get:
2011-01-21:14:09:46.421335,Eric,San Fran,550,
2011-01-21:14:09:46.421335,Eric,,100,
is there something wrong there? how can I get these output in my file:
I,CUSTOMER,2011-01-21:14:09:46.421335,Eric,San Fran,550,
V,CUSTOMER,2011-01-21:14:09:46.421335,Eric,,100,
Here is my params for extract: