[resolved] cast type of key from NVARCHAR to INT

[Anonymous]

Hi,
I have a key type as NVARCHAR from MSSQL database. In my job I want to perform the join between two tables based on this key (I'm able to to this) but just after I want to convert the key table from NVARCHAR to INT in order to insert it in a postgres sql database.
In which step i can do that I want?
1) Convert and than join the table?
2) In the tMAP in which the join is executed?
3) Or after in the tPostgresqloutput step?
Thanks

[alevy · Accepted solution]

In the tMap output define the column as Integer with an expression like Integer.parseInt(row1.key)

[Anonymous]

Thanks!