https://documentation.matillion.com/docs/2147237
Matillion ETL derives the structure of the target table from the source metadata, and not from the files generated in the staging location.
Not sure what is the question here ?
The field attributes types are not same as source. We resolved it by using JDBC Metadata to Grid component and then creating a target table.