I have an ETL process defined in DW Center from a AS400 library file. The extraction process loads data but with the following values for all the records: [N/A]. If I do a sample content, no data is retrieved.
I noticed that it has to do to with the character code setting which is different for this file. It can be changed in the library, but I would like to know if at the connection to the AS400 level I can set a parameter in the configuration that when importing metadata and the data itself I can get the expected result.
Is there a workaround other than changing the character code in the AS400 library?