DSXchange

Yes ,i am using the same syntax ,And i am doing this in a Transformer Stage!

chulett wrote:First off, what makes you think it is not working? What is your target field after the trim, another varchar or a decimal? ...

I tried it, and the output is not changing. The target Column datatype is also Varchar!

I need the following requirement: Input Sample 000029.96 00000.00 00156.01 00007.12 Required output: 29.96 0.00 156.01 7.12 The dattypes varchar!! i used the TRIM function to remove the leading zeroes... TRIM (Link1,'0',"L") But it is not working... Can anyone suggest me a solution.. Thank...

By Changing the link Order ,You can achieve the Right outer !!

Force Compile the job and try to run..

check here for a resolved issue:

viewtopic.php?t=120544&sid=97db989c6061 ... f7c60a7558

Please Search for the issue in dsxchange befor posting a new POST

Hi All, I am facing compiling issue with one of my job. Even if I tried to save also i am getting the same issue. Error: Unable to save EditServ.impl.JobDefiImpl@25ae25ae Thanks Vijay Cleaning up of the Repositary could make some improvement in your issue. Delete the unwanted jobs or export the job...

Can you tell the exact job design and the stages used in it..?

Validate the Constraint that u mentioned in Link2...

You are getting the records from Oracle ,Then whts the datatype in it?
Can you able fetch the records from the Oracle as the datatype may be relevant?

Can anyone guide me on the following issues
1.What is the exact nature of the proerty INDEX mode?
2.What to do in the dba side to have this property?
3.Is there any option to resolve this issue other than the above thing?

Thanks in advance,

HI all,
The problem is solved now,I removed the INDEX MODE option from the properties itself . now the job is running fine without wsrnings and errors

Regards,
R@j

I tried changing the INDEX Mode in the property Tab of the target ORACLE stage to 'maintenance' from 'Rebuild', When i execute it , Some new errors are arised ending with the job with status ABORTED (This time no records are passed through the links and it havent changed to Green) Here are the error...

Hi all, i am running ajob that loads data from dataset to a Oracle database. I am using lookup stage to reject the already excisting records in the table and load all other records to the table While executing the JOB,i find the following errors and job ends stating ABORTED (But the rows are passed ...

Explain about the difference between the jobs :either stage wise or property wise