Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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