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?
... View more