It is a very good point, Mike :
Using Stage variables, you have to be very very carefull with the last line (or the first depending on the case)...
Usually, it try to avoid them for this kind of things...
Search found 12 matches
- Thu Jan 27, 2005 10:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is Incremental Aggregation possible
- Replies: 18
- Views: 10315
- Thu Jan 27, 2005 10:31 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is Incremental Aggregation possible
- Replies: 18
- Views: 10315
kcbland, it is not a mod(), but a div... I you truncate the resulting number, you will have the right group (truncate and not round)... 1 / 5 = 0.20 int(0.20) = 0 2 / 5 = 0.40 int(0.40) = 0 3 / 5 = 0.60 int(0.40) = 0 4 / 5 = 0.80 int(0.40) = 0 5 / 5 = 1.00 int(0.40) = 1 6 / 5 = 1.20 int(0.40) = 1 .....
- Thu Jan 27, 2005 9:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is Incremental Aggregation possible
- Replies: 18
- Views: 10315
In your example, it is a sum and not an avg... Anyway, this might do the trick : In a transformer before the aggregator add a column to your stream containing the value Int (@OUTROWNUM / 5) Like this, your data now looks like : a,5,0 a,3,0 r,6,0 y,2,0 i,5,0 q,3,1 o,4,1 t,3,1 If you then sum (or avg)...
- Tue Jan 25, 2005 8:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Monetary Conversion
- Replies: 4
- Views: 3348
I think it is more like :
Code: Select all
OConv(number,"MD2[,'.',',',,]")
- Mon Jan 24, 2005 10:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: problem with sequential file
- Replies: 7
- Views: 4163
- Fri Jan 21, 2005 4:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Removing the warning from the log file
- Replies: 3
- Views: 2798
Moreover, when you have a lot of activity with the log file (like one warning per line) the performance greatly suffer... It also remind me of this time, when I get used to see in director : Finished (see log) and missed a really important warning... From this day, all my jobs are finishing without ...
- Wed Jan 19, 2005 11:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: data cleansing
- Replies: 7
- Views: 8686
- Wed Jan 19, 2005 9:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate jobs
- Replies: 9
- Views: 5147
- Wed Jan 19, 2005 7:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate jobs
- Replies: 9
- Views: 5147
- Mon Jan 10, 2005 4:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: performance issue
- Replies: 8
- Views: 6033
- Fri Jan 07, 2005 9:52 am
- Forum: Site/Forum
- Topic: RSS Feed now available
- Replies: 5
- Views: 31239
Re: RSS Feed now available
If you would like to receive these notifications, but do not have an RSS aggregator, you can use <a href="http://www.ceruleanstudios.com/products/">Trillian Pro</a> ($25 download), <a href="http://www.feedreader.com/">FeedReader</a> (Free download) or any other RSS 0.9x compatib...
- Thu Jan 06, 2005 2:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pulling the most recent file out of a directory
- Replies: 10
- Views: 7507
You can have the last line using pipes instead of using a temporary file :ketfos wrote: ls -t > temp
tail -1 temp
Code: Select all
ls -t | tail -1