DSXchange

Depends on how huge it is ...
Try downloading a free version of TextPad.
There is a feature to sort the delete duplicate lines.

attu wrote: No. of groups (modulus) .... 12003 current ( minimum 1, 0 empty,
3896 overflowed, 1 badly )

Not sure what the meaning of "badly" is in the above context?

attu,

That would depend on your requirement.
There is a small application called HFC.exe available on your Datastage Installation CD. This can help you tune your hashed file.

First establish a pointer in the VOC by issuing the command
Next

As already pointed by Craig, you don't need to delete the job logs.
If you are able to open your job, you should be good now, enjoy!

reachmexyz wrote: So in the director, i opened the clean up resources and tried to logout the process. How many times i do it still show up.

Try logging in as admin and repeat this process.

To test if the hashed file is the real culprit - split your job into two.
First job - Write your output into a sequential file.
Second job - Read from the sequential file and write to the hashed file.
This way you can identify, whether its your job design or the hashed file is the bottleneck.

satyame171 wrote: "a non-numeric character was found where a numeric was expected" .

The solution is in your error message. You might be trying to insert a non-numeric character where a numeric character was expected.
Check for consistency in your source data, see if you need to do any conversions.

I would start by looking for the database entries in the uvodbc.config and .odbc.ini file

For starters - check your Precision and Scale values.

Delete the column id and use the below query.

Assuming '%' is your delimiter, use

I second your finding. I just got curious and checked it out with my similar setup.

Ray meant, that you need to handle the NULL's.
Check out some of the NULL Handling functions available.

Right(Arg1,3)
Or did I miss something from your requirement?