DSXchange

Hi,

I am using the Merge stage.and i have set the 'pure inner join'.


Merge-------->Transformer---->seq_file.

when i run this job i got an error saying that 'FUNCTION get_next_output_row' failed.
[Input file : xyz.TXT] End of row termination characters expected.

where do i set these properties?.any help would be appreciated.

TIA

Hi,
usually it's in the output tab under the input files properties under first or second file format tab.
naturally the settings there must match to the actual ones of the file.
IHTH,

Check whether there are more cols or chars in the file than mentioned in the properties.

Save the metadata of those input files and load the metadata while specifying the metadata and specify the delimeter etc as mentioned while those files created.

HTWH.

Regards
Saravanan

Hi,
You should include all the columns from both the files in the output window even though they are same , and you can ignore them if you dont need once it is out of the stage, that way it doesnt give the error you are mentioning.
Good Luck

Hi,
Thanks for all for your input.But, still iam getting the error.
In the merge stage iam using pure inner join.If there is no key column matches merge stage raises error like " Function 'get_next_output_row' failed [Input file : xyz.TXT] End of row termination characters expected."

If key column matches it works fine.

what could be the reason?. any clues pls.


TIA.

Hi,
can i use the merge stage, if there is no matching key column in input files?


TIA

No