Four Stars

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?

 

4 REPLIES
Twelve Stars

Re: column aliases in tMysqlinput are not transferring through in guess schema

@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.

Manohar B
Twelve Stars

Re: column aliases in tMysqlinput are not transferring through in guess schema

@tshorrocks,still do you have this issue?

Manohar B
Four Stars

Re: column aliases in tMysqlinput are not transferring through in guess schema

I'm good. I got the question answered as to whether the tMysql input was capable of transferring those aliases through. Thank You!

Twelve Stars

Re: column aliases in tMysqlinput are not transferring through in guess schema

@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..

Manohar B