FTP Stage not sending Columns as First Line

[syang@collaborative.com]

Hi guys,

I currently have two FTP jobs that use the FTP Enterprise stage. Both jobs have exact same settings, FTP from a Netezza Connector, and write a .txt file to a directory. The weird thing is that one .txt file has the column names as the first line, and the other does not.

The first job uses this query in the Netezza connector(no column names):
SELECT Supplier_ID,
Supplier_1,
Supplier_2,
Supplier_3,
Supplier_4,
Supplier_5,
Supplier_6,
Supplier_7,
Supplier_8,
Supplier_9,
Supplier_10,
RTrim(Supplier_11) AS Supplier_11,
Source_System_Code
FROM dim_supplier;

The second job uses this query in the Netezza connector(has column names):
select * from dim_item;

I know that the FTP plug-in has an option for column names. Since I don't see any option to have the column names as the first line in the FTP Enterprise stage, I was just wondering why one file has column names and the other does not.

Thanks.

-Sou

[syang@collaborative.com]

Hi guys,

It seems I was looking at the wrong files. Both FTP files don't have any column names as the first line.

[chulett]

That makes more sense as the stage (for whatever reason) doesn't support that option.

Just a quick fyi - doing a "select *" in a tool that is metadata driven is generally considered a Bad Idea.