DSXchange

From 4 - 20 months time from now.

1. The key mentioned in the Sort stage Sort_475 does not match the keys mentioned in "Join_479" Join stage.
Note: It should exactly match in all the case.
2 and 3. Column "AREA_ID" is marked as Char or Varchar in Input tab of the Join stage and Integer as Output tab of the Join stage.

File will be definetly create when you have the link.
Either you need to pre process or Post process for this.
Either you can check for the size and remove it from the OS or pass different value to the parameter to the job if the file need not to be create at some specific condition, say /dev/null.

If you search this forum, you can easily find that you may either need to increase the temp space or cleanup the temp space for this error. You may also find that the link followed by Modify to Modify or to Peek statge doesn't show up the statistics. And moreover, you will not get the exact number w...

Inspite of repeated post, somehow I didnt noticed the CONVERT function within Trim.
Nagesh - Arnd has already explained the way how CONVERT works.
I shouldn't be wake up even after 12:30 AM.

Also check the record terminator / delimiter settings.

Hi Welcome to Dsxchange!!! :D
You should be able to check the data in you source for the unicode avaialblity. Sometimes you viwer might not show it, so better export to a flat file and have a view.

'cat -e' does that. Will 'cat -v' too do the same? I dont have access to Unix now.

Again you are eliminating the 'ABC' with '' opton passed. Where the possible options are 'L', 'R','B'...
Try to convert to some other characther. You can find the difference.

Search the forum, you can find a post in the same regards. If you were not able to convert the lookup data, convert the input stream according to the lookup, you have ustring_from_string functon avaialble in transformer. If its Char, I usually prefer to convert it into Varchar. You can edit the data...

you can find some files been used in ranges of 2000 - 2500 columns.

Actually Trim function eliminates the given string and not the conversion.

If it is CFF stage and the file is Ebcidic, no other go, you need to under go this pain. But if its Sequential file, and if the added field comes to the last, and if the last column of the exisiting fiels are varchar fixed width, and if the additional colum is not required by other jobs or tables, y...

I could see that, the stage variables are used for Null handling. Where are you updating the other values?
Are you sure, that the value are not inserted after updated in the same run?

If both the stream keys are varchar, shouldnt it take care by it self?