Reorder Columns in the OGG Trail for OGG Adapter
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate Application Adapters - Version 220.127.116.11.4 and later
Information in this document applies to any platform.
is it possible to reorder the columns in the flat file adaptor. For example
Source table : column1, colum2,column 3,column 4, column 5,column 6, column 7
Out of which we are extracting column1, colum2,column 4, column 5,column 6, column 7 using cols in extract parameter.
So the Question is : in the flat file adaptor , i need to extract data in below format.
column7,colum2,column 4, column 5,column 6,column1
so the output DSV file will have data in this order.
How can i achieve this ?
call me for any clarifications
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms