Clarification needed on output of job stage

ag_ram · Post by **ag_ram** » Tue Sep 04, 2007 3:41 am

For some stages like pivot and aggregator stage one of output column of has a special character (new line e.g one rectangle box) appended with output data.

Please clarify me why these stages are appending a new line character? How can we rectify this problem?

Note: We have checked the source data for pivot stage which does not have any new line characher as input but the output has it. Same thing with aggregator stage.

JoshGeorge · Post by **JoshGeorge** » Tue Sep 04, 2007 4:35 am

Writing into a fixed width file? Is the 'rectangle box' appended to fields which are defined as type char? Set the APT_PAD_CHARACTER to space and see if that solves the issue.

ag_ram · Post by **ag_ram** » Tue Sep 04, 2007 5:11 am

JoshGeorge wrote:Writing into a fixed width file? Is the 'rectangle box' appended to fields which are defined as type char? Set the APT_PAD_CHARACTER to space and see if that solves the issue.

I am not writing to fixed width file. The column in corcern is varchar.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 04, 2007 4:17 pm

Please advise what the solution was that caused you to mark this thread as Resolved.