ODI using SQL Unloader generate CSV File

Summary:

ADW as a source system

We are using ODISQLUNLOAD to generate comma separated CSV files .

We are using union to cominbe the table columns and header

Now as a result csv file is generating but all the columns under one head (column1) where as expectation is to generate CSV file with N columns (means as many columns in SQL we have in SQL statement)

Is any configuration achieve same that we can use in ODI

Present O/P is

Expected O/ P is

ODI Configuration Used

Applied query in ODI is

with csv_file

as (select 0 line_no,

'JE_SOURCE_NAME' AS JE_SOURCE_NAME,