on 05-03-2016 9:55 AM
Hi Charity,
Some where when defined the flat file format you may given it as fixed length defaulted so that BODS auto padding with blank spaces to maintain fixed length.
Please check the flat file format or any where if you opted for fixed length for columns
Check also ,whether kept CHAR or VARCHAR as data type??
Thanks, ..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Don't know why is it happening but you can add rtrim_blanks() function in query transform to remove it.
thanks,
Pravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Charity,
What kind of data are you trying to load. I see that the characters are unicode. Try changing the Code Page of the File Format to code page(US-ASCII) of data which is compatible with the Target database.
For example, the Japanese code page contains ASCII, Greek, Cyrillic, and Japanese characters, thereby supporting the English, Greek, Russian, and Japanese languages
For more details refer DS 4.2 Reference Guide.
Hope this helps!!
Regards
Arun Sasi
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.