Junk Character missing in Attunity replicat

[Gopikrish6]

Hi All,

Source as Db2 column datatype as (CHAR(24) FOR SBCS DATA NOT NULL WITH DEFAULT), While in Attunity replicat showing as CHAR(50) but it replicat to Sql server as blank Values.

Then i changed into WCHAR(50) Even i get blank values.

Kindly share your suggestions to replicat the junk characters in the Sql server target.

Thanks,

Gopi

[Gopikrish6]

Hi Qlik Experts, 

Still am not getting proper solutions for the COMP 3 Packaged decimals convert HEX into INT.

Kindly  share the Solutions.

Thanks,

Gopi

[shashi_holla]

Hi @Gopikrish6 

You can add the same logic in table level transformation to the column if its working in SSMS:

CONVERT(INT, CONVERT(VARBINARY, $COLUMN_NAME, 1))

Thank you,