You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ODI using SQL Unloader generate CSV File

Received Response
144
Views
3
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!