Page 1 of 1

Posted: Fri Sep 26, 2008 9:04 am
by WoMaWil
Dear Senthi,

it is not as simple as you thing. The letters you mention should work without special NLS-settings in DataSTage.

You have first to look at source and target and if both of them are able to catch the letters.

Where do you get your data from and where do you want to leave them?

Posted: Sat Sep 27, 2008 4:03 am
by samsuf2002
What is your target ?, if it is a file then you can pass it through another transformer and put a constraint to capture ?s for that column and reject it.

Posted: Sat Sep 27, 2008 4:07 am
by ArndW
Approach the problem step-by-step, as Wolfgang has suggested. What is your source character set? What character set would you like as your target?

Posted: Mon Sep 29, 2008 7:42 am
by senthilmp
Hi, Thanks for your response.
The source and target character set are of NLS UTF-8 setting. And i want the special characters which is not processed to capture in the Reject file, then only we can correct it and re process again.

Posted: Mon Sep 29, 2008 11:02 pm
by senthilmp
No these characters are not accepted by UTF-8 Coding, these are converted as '?????' and written into target, thats the problem i am getting.