Reorder Columns in the OGG Trail for OGG Adapter (Doc ID 2193601.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 12.1.2.1.4 and later
Information in this document applies to any platform.

Goal

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
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms