DSXchange

We moved data from JDE DB2 whose type was CHAR into Sql Server NCHAR. SQL server uses 2 bytes for NCHAR and NVARCHAR.

If CHAR 10 needs to be moved into NCHAR10 then what is the right lenght in Datastage for table def-
A. CHAR10 to NCHAR10 (OR)
B. CHAR10 to NCHAR20

If I was performing a lookup on NCHAR10 to NVARCHAR10.
A. Would I need to convert NCHAR10 to NVARCHAR10 and then perform a lookup?
(OR)
B. NVARCHAR10 to NCHAR10 and then perform a lookup.

Thanks!

Import the SQL Server table definition and use whatever is imported.