I have a tMysqlinput going into a tMap and then into a tOracleOutput.
source query is
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,still do you have this issue?
I'm good. I got the question answered as to whether the tMysql input was capable of transferring those aliases through. Thank You!
@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..
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.