Search found 96 matches
- Fri Jul 12, 2013 8:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alpha characters in Decimal Field
- Replies: 12
- Views: 6973
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...
- Thu Jul 11, 2013 6:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Alpha characters in Decimal Field
- Replies: 12
- Views: 6973
Alpha characters in Decimal Field
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...
- Fri May 17, 2013 2:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Logic
- Replies: 7
- Views: 3183
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 ...
- Wed May 15, 2013 2:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Logic
- Replies: 7
- Views: 3183
Re: LookUp Logic
No. I am running it on one node.
- Wed May 15, 2013 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Logic
- Replies: 7
- Views: 3183
- Tue May 14, 2013 2:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LookUp Logic
- Replies: 7
- Views: 3183
LookUp Logic
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 ...
- Fri Dec 14, 2012 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Repetition Elements in XML
- Replies: 5
- Views: 3150
- Fri Dec 14, 2012 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Repetition Elements in XML
- Replies: 5
- Views: 3150
Repetition Elements in XML
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...
- Wed Nov 14, 2012 11:15 am
- Forum:
- Topic: Editing runimport.cfg
- Replies: 0
- Views: 1062
Editing runimport.cfg
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...
- Fri Oct 26, 2012 1:17 pm
- Forum: General
- Topic: parallel jobs with warning
- Replies: 9
- Views: 4567
- Wed Oct 17, 2012 2:39 pm
- Forum: General
- Topic: deleting jobs manually as they are locked in xmeta.
- Replies: 4
- Views: 2741
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....
- Mon Oct 15, 2012 3:10 pm
- Forum: General
- Topic: Passing parameters to a Email Stage from Table
- Replies: 5
- Views: 3074
- Mon Oct 15, 2012 3:04 pm
- Forum: General
- Topic: Passing parameters to a Email Stage from Table
- Replies: 5
- Views: 3074
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...
- Tue Oct 09, 2012 3:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: datastage warning
- Replies: 4
- Views: 2386
- Tue Oct 09, 2012 7:38 am
- Forum: General
- Topic: need help with sending an email from my job
- Replies: 4
- Views: 2491