DSXchange

Hi,

I have the following date value in the input file 07/31/2008 10:00:34
When i try to load it into the oracle table it is giving me insert error. what is the format to convert using iconv and oconv.

Thanks!

Thanks a lot!! and it worked.

Hi,

I want to output today's date in one of the output column in a sequential file. The output format is mm/dd/yyyy. I am trying this .OConv(@DATE,'D/YMD[2,2,4]'). But it is not working..can anyone help me out.

Thanks

Hi, I have a server job where i am reading a fixed width file and separating the columns using a transformer. Again i am using one more basic transformer to do the validations. If i do all these in a single transformer, will the performance improve. This is some existing design, where i am trying to...

I am using Oracle DB Thanks Ray for your response. What about sorting here.Will it not consume more scratch space with the sort stage. This 40-50 million is going to increase to 140-150 million by the next release. Since i considered 50 million is huge, i am using join stage everywhere..What about u...

Hi, I have a job where i extract about 50 million records from a table. I join the records with another table which also has around 40 million records on key "A". Later i split these records based on a conditions into 3 links. Again i have to join these three links (each individually) with...

i have both the dev and uat environments in the same unix server. since there is no issue with the dev, i am not sure why it is giving issues in uat. That is why i confirmed that c++ compiler is installed properly.

Hi, When i try to compile a parallel job it gives me the following error messages. ##I TLIC 000002 05:59:43(000) <APT_LicenseCheckOp in APT_LicenseOperator,0> Node 'etldev1' has 12 physical processors. ##W TLIC 000003 05:59:43(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> DataStage has found mo...

I had defined all the columns in the seq file stage with a default length(it had taken as 255). I just changed the column length of the join key field to its original field and it is working fine now.
But i am wondering why it was not joining the column which had & in its value. Looks wierd.

Hi, I have a file which i am joining with a oracle table using a varchar column name. The name contains ampersand(&) in the values. But even if there is a join between the file and the table these records which have (&) contained in the column "name" are not being populated in the ...

Thank you. I Saved the metadata and then loaded them in the output link.

Hi, I am new to server jobs. How do we map the fields from input to output in server jobs..In parallel, we have the Mapping tab where we drag the required fields from input to output. In my job, i have oracle table-->transformer1-->hashfile1-->transformer2-->hashfile2. The output fields of transform...

Hi, I have few jobs which i have to modify as there is a requirement for enancement. In the same time, these jobs which are in production are being changed by the production support team..Is there a way where i can do the merging of both the changes(i.e changes being done by the support team and the...

I closed the designer client and re-opened it..now i dont have any issues in compiling..it looks wierd.

Hi , While compiling i am getting the error. When i click More, then this is the message it shows. i couldnt see any error message here..but am not able to compile. Can anyone help. Compiling: Source = 'RT_BP602/JOB.1724735424.DT.1469011334.TRANS1', Object = 'RT_BP602.O/JOB.1724735424.DT.1469011334....