DSXchange

Thanks guys for the help. Sura - I dont want to check if the data is valid or not as business is saying that it is valid data. They gave me a chart for conversion. For example J means that position has 1 and the number is negative. K means that it is 2 at that position and is negative and so on. Bel...

Hi Guys!!!! I have a fixed length file and I have to extract data for AMOUNT field from fixed length field. AMOUNT is stored in flat file from 11-20 position. In target along with AMOUNT field there are many other fields also. Sequential File -----------------> Transformer -----------------------> T...

Craig - I think that since Look Up uses Entire Partitioning. It takes any record even though the job runs on single node and the look up data is sorted. Kunal - I didn't try your suggestion but I think it looks a lot of work. Soumya - Both the source and lookup record are in different databases. So ...

No. I am running it on one node.

Ray,

I am doing the same thing but the issue is that I have a look up. It picks up any value randomly even though the LookUp data is sorted. Some times it takes Col4=101 and sometime Col4=102 as Lookup uses entire partioning.

But, I want to get next max number i.e. Col4=102.

Hi, I need help with getting some logic. Below are my Source and LookUp tables. I want to do a look up on Col1, Col2 and for Col3 I want to get the max value but less than source. For the below example I should get Col4=102. Source Col1 | Col2 | Col3 101 | 1 | 5 LookUp Col1 | Col2 | Col3 | Col4 101 ...

Ray,
Currently I designed a server job(8.5), But if there is any possible solution on designing a parallel job then I will go ahead with it.

Hi, Here I have a huge XML with so many repetition elements like, <admin> <quoteback name="caseId">SHAWN AABROWN</quoteback> <quoteback name="caseId">BROWN</quoteback> <date_request_completed>08/15/2012</date_request_completed> <date_request_completed>15/2012</date_request_comple...

Hi Guys, I have a requirement that I want to build a table as shown below: DS Job_Name | Source_Name | Source_Type| Target_Name | Target_Type | LookUp_Name Job1 | ABC | Oracle | XYZ | Oracle | DEF, GHI, JKL Job2 | ABC1 | Text Files | XYZ1 | DB2 | DEF, GHI1, JKL1 Source_Name - Name of the source tabl...

It is not a good practice to have warnings, if you can eliminate it.

But, if you don't have time then you can use Message Handler to not abort the jobs.

I don't know if this link will help you. But, you can give a shot at it for deleting the job from Unix. Once, my project was corrupted and I could not see the job in Designer but it was present in Director. So at that time I found the below link to delete the job manually. http://publib.boulder.ibm....

You don't even need to put User Variable Activity.
You can directly use $CommandOutput to read the output from cat command.

#ExecCommand.$CommandOutput#

Even if you write a parallel job, you don't need to have 3 stages to read and 3 files. Read the data from Oracle and write on a single file. For example, Test.txt abc@gmail.com~def@gmail.com~Test Mail And then read the file using CAT command in unix. And later using FIELD() in the parameter assignme...

I guess the warning is coming from transformer.
And it is generally from the Stage Variable in the transformer.

Is there any transformer in your job with Stage Variable?

I have got the below code from http://www.unix.com/shell-programming-scripting/118534-sendmail-attachments.html link. And I have used this one. It works. #!/usr/bin/ksh export MAILTO="email_address" export CONTENT="/export/home/aisdba/email_body.html" export SUBJECT="subject...