column aliases in tMysqlinput are not transferring through in guess schema
I have a tMysqlinput going into a tMap and then into a tOracleOutput.
source query is
SELECT hex(id) as id ,start_time as start_tm ,end_time as end_tm
,etc, etc, etc...
when i click guess schema it comes back with the original column names. this makes it difficult in the tMap since auto map wont pick up the matches and i have to manually drag each source column to its destination.
I don't have access to the source system to create a view otherwise i would do that.
What is a more efficient way of mapping a large number of columns when the source and destination names don't match up?
@tshorrocks,If you click on the Guess schema ,you will get the orginal column names.since you need to add alias coulmn names manually in shema of tMysqlInput. From there aliases wil come to tMap and tOraclOutput.
@tshorrocks,yes you can use aliases,since you should not go by Guess Schema,Schema should be contruct based on aliases manually or create a Generic schema based on aliases and use that Generic Schema in tMysqlInput..
