One Star nko
One Star

[resolved] cast type of key from NVARCHAR to INT

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
1 ACCEPTED SOLUTION

Accepted Solutions
Seven Stars

Re: [resolved] cast type of key from NVARCHAR to INT

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

Re: [resolved] cast type of key from NVARCHAR to INT

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

Re: [resolved] cast type of key from NVARCHAR to INT

Thanks!