DSXchange

Use transformer stage, route duplicates into one stream and others into another stream. You can do this by checking if the current value is the same as previous value or not with the help of stage variable(s).

Try passing values: (1A, 23, 4ED) to the job parameter: pEmpId and use IN (#pEmpId#) in the WHERE clause.

Is this the only symbol that is not showing up OR none of the symbols are showing up?

DD,

Here's a work around if you can manipulate the source file outside of DataStage. Replace """ with " or nothing in the source file, save it, and try importing the data again.

Kumar,

I am running into the same issue and trying to resolve it. Were you able to find a resolution yet?

Ankita,

Any luck with this error?

I am running into a similar one (Unicode to UTF-8) but couldn't find any relevant posts except yours.

Did you find any more information on the error?

Here's a work around. Basically, deleting the MNS stage and recreating it resolved the issue.

Thanks for the quick response. We will pursue it with IBM support.

We are running into the same set of errors and are trying to figure out what could have caused it. Have you had any luck yet ?

Kanyaviyasari -- Are you using any Job Parameters?

OK, then you can compare them without converting and pick the max.

What is the date format in the Input fields?

I have seen such an error when the number of warnings have reached the maximum limit. If you are indeed seeing a lot of warnings, then either correct them or change the setting to unlimited warnings and try again.

In response to your first question: The following functions should work in Server: IsNull NullToEmpty NullToZero and you could make use of "Not" and "IsNull" together to get the same functionality of "IsNotNull". I don't believe the rest are available in Server. Hope th...