Search found 150 matches
- Thu Aug 19, 2010 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_DecimalNumber::convertToDecimal: the precision is not
- Replies: 5
- Views: 4321
APT_DecimalNumber::convertToDecimal: the precision is not
Hi Im having trouble with decimal multiplication. I have a source field (Col1 datatype in oracle is Number) and one more field thats(col2 datatype in oracle is Number). here is a sample: Col1=386.48 Col2=0.27225701061802341410291315001361285053 (no rounding is allowed) Now if i do this calculation i...
- Tue Apr 27, 2010 10:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No Logs found in DS Director
- Replies: 5
- Views: 1728
- Tue Apr 27, 2010 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No Logs found in DS Director
- Replies: 5
- Views: 1728
- Tue Apr 27, 2010 10:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No Logs found in DS Director
- Replies: 5
- Views: 1728
Hi I checked the DSParam file and I see this: RTLogging=0 ORLogging=1 Should I change this to RTLogging=1 ORLogging=0 One more question, when I opened the DSParam file I made a copy and then opened it with wordpad, so can I directly edit or make changes and new file in place, will this affect the ex...
- Tue Apr 27, 2010 10:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: No Logs found in DS Director
- Replies: 5
- Views: 1728
No Logs found in DS Director
Hi I'm trying to view the job logs in DS Director and i'm not able view any logs. I tried to search the forum and found results only for DS on a UNIX machine and not for windows. From other postings I see that I need to change / check the values for RTLogging and ORLogging, but i'm not sure where to...
- Tue Mar 09, 2010 5:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can we implement is DS PX
- Replies: 6
- Views: 2830
- Mon Mar 08, 2010 4:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: writing to AIX sequential files and DB2 concurrently
- Replies: 5
- Views: 2490
- Mon Mar 08, 2010 4:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stable sort option in sort stage
- Replies: 6
- Views: 13522
- Mon Feb 15, 2010 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading large strings
- Replies: 4
- Views: 1928
- Mon Feb 15, 2010 1:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting a string to Date
- Replies: 7
- Views: 32475
- Fri Dec 04, 2009 4:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart sequencer after abort
- Replies: 13
- Views: 6791
Hi First if you want to restart the sequence from where it aborted, as mentioned previously you need to know where it failed, ie the point of failure. so try to get this information first. In my system, what we do is all the job activity will have a number and we have a seperate file where we store ...
- Fri Dec 04, 2009 4:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row value to be populated in all the fields
- Replies: 5
- Views: 1429
Hi I assue the following: RowNumber -varchar Model - varchar Custnum - integer state varchar2(2) to convert all null model to '02' you can use a modify stage: MODEL_NEW=HANDLE_NULL(MODEL, '02') or if you think that the input is very less and you have a transformer, you can convert all the 00 to 02 a...
- Sat Oct 24, 2009 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator + Performance
- Replies: 5
- Views: 2158
- Sat Oct 24, 2009 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator + Performance
- Replies: 5
- Views: 2158
- Sat Oct 24, 2009 1:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator + Performance
- Replies: 5
- Views: 2158
Aggregator + Performance
Hi I have the following data: Loan_Id Amount Produts_Id Store_Id 1 1000.9 55 12 1 .082 55 12 2 2000 55 32 3 0.8776 55 05 2 9.8 55 32 3 1000 55 05 the total number of records is 28.4 million. No Of Nodes: 2 stages used: oracle---->agg (group by loan_id, product_id, store_id, sum(amount) partition was...