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

Last updated on MAY 11, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.