Pass data from tmap as stream output to tFileoutputPositional
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.