DSXchange

I just fixed a similar warning and this solution worked for me.

I changed the column defintion as Varchar() and set Unicode in the extended property, in the job that threw the warning.

Check if this works for you.

Hi,

whenever I open data stage director,I got one error for one job.I am unable to understand this problem.the error is

Can not open the executable file RT_CONFIG623

Thans in advance,
Sandhya

The lowest hanging fruit is indeed a hashfile as im looking up and updating the hash file within the same server job. If lookup is not found then hash file would also be updated with new record. As i now have to pull these 25 columns i have to update the hash file also if any older records have been...

Thanks everybody for the replies, I will try working around it. i'l try the procedure else i have to stick to the lookup concept and implement the CRC32 funda and test the performance. :( Thanks a Lot!!!!! Any other suggestions would also be of great help. The only other solution off the top of my h...

Hi Kritikumar, The solution what you have given is exactly what i have alreday done. But there are 25 such columns so i have to pull 25 columns from the target table into hash file.And also the hash file is being updated in the same job.Also the input columns have complex derivations to derive the o...

Thanks for the reply, I would follow your suggestion and test with CRC32 function to update the hash file and test the performance. But what my real concern is the condition below if status = 'A' then target column = 'aaa' else if status = 'B' then target column = 'bbb' There is no closing else cond...

Hi, I have done a server job which inserts new or updates existing records.The hash file is also updated in the same job.Im doing this using a lookup on the key column. I have several transformations as below for individual columns If input is A Then "All" else If input is B Then "Bal...