Pass data from tmap as stream output to tFileoutputPositional

borrisbeck — Thu, 18 Feb 2021 15:47:49 GMT

I'm trying to create a generic job to load fixed width files, But sometimes the files may contain additional characters, in that case, that record needs to be rejected, I have designed a job, where I'm passing the file metadata to "tSetDynamicSchema" and table metadata by context parameters.

In order to get the length of the records to check for additional characters, there is no direct way to get it from tFileinputpositional, So I used tFileInputFullRow to read the whole record and filtered out records with additional characters using tmap. Now I want to pass the dynamic column output from tmap as streamoutput to tFileoutputpositional.

Any idea how can I get the output from tmap and pass it to tFileoutputpositional as streamoutput?, so that it can be loaded into the oracle table.

I have marked that section in blue.

Re: Pass data from tmap as stream output to tFileoutputPositional

manodwhb — Tue, 02 Mar 2021 09:14:17 GMT

@maximus jack ,check the below link.

https://help.talend.com/r/qv1pRZZ~V2OH8sAgI2gmvQ/cGB0fvqBFWGCOLgBcpmCww

you need to use below way.

((java.io.OutputStream)globalMap.get("tDropboxPut_1_OUTPUTSTREAM"))

Thanks,

Manohar

topic Re: Pass data from tmap as stream output to tFileoutputPositional in Talend Studio

Pass data from tmap as stream output to tFileoutputPositional

Re: Pass data from tmap as stream output to tFileoutputPositional