Did you use only one Schema file. If only one shema file, what is the need for parameterizing the Source file name, Target table name.I am also having a similar issue.
I tried using the schema file as a parameter for the sequential file stage(which is the source) and it works perfectly.
The problem starts when i try to parameterise the target table, as i dont see any option to use a schema file in any of the DBMS stages.
That means i am able to parameterise the source file name, souce file definition and the target name, but not the target table definition and under these conditions my metadata for the source and target are not matching.
If you used multiple schema files, How did you generate the schema files? How did you determine at run time that this schema file has to be used for this particular source file?