Search found 45 matches
- Tue Jul 10, 2007 6:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning - Aggregator Stage
- Replies: 6
- Views: 3878
- Tue Jan 09, 2007 12:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TimeStamp problem
- Replies: 6
- Views: 3089
- Thu Jan 04, 2007 6:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Input Stage
- Replies: 10
- Views: 4765
- Thu Jan 04, 2007 1:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP using parallel job
- Replies: 5
- Views: 2470
- Wed Dec 27, 2006 12:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup with multiple columns
- Replies: 31
- Views: 11920
wow that is nasty. The number of combinations is outrageous. I was thinking a separate lookup for each combination but 462 lookups is too much. I am sorry, perhaps some of the other professionals would be able to help you with this. This may be possible using awk, but I dunno how good it would be pe...
- Tue Dec 26, 2006 8:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup with multiple columns
- Replies: 31
- Views: 11920
Re: lookup with multiple columns
I have a file with fields some of the fields of the file may contain "*" as values, then match with the remaining columns and retrieve the col8 from table. Do you know exactly which fields would contain the "*"? How many of those fields "could" contain "*"?
- Tue Dec 12, 2006 1:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sparse lookup possible in SE?
- Replies: 3
- Views: 1976
- Tue Dec 12, 2006 12:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sparse lookup possible in SE?
- Replies: 3
- Views: 1976
Sparse lookup possible in SE?
I performed a search but could not find any information about sparse lookups in server edition. Does anyone know if it is possible? I know that PX has this option.
- Tue Nov 14, 2006 6:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup
- Replies: 4
- Views: 2071
- Mon Nov 13, 2006 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Sequencing
- Replies: 4
- Views: 2940
How are you going to keep track of the number of times the job has run? Are you using command line to kick start the job? If you can pass the number of iterations as a parameter, then it would be easy to implement using job sequence triggers. I need a little more information about what you want to d...
- Tue Oct 17, 2006 1:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DecimalTochar Conversion
- Replies: 1
- Views: 2835
Type Decimal fields will always has a byte for the sign and a byte for the decimal. So if you have Decimal[9,0] and it is a positive number your number will be like this: space+123456789+period So what you want to do is trim the space and period. Try Trim(Trim(DecimalToString(%num%,%option),'.'),' '...
- Tue Jul 11, 2006 2:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling Custom routine using environment variables
- Replies: 3
- Views: 1441
- Tue Jul 11, 2006 2:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: date generation
- Replies: 2
- Views: 1721
- Mon Jul 10, 2006 10:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference bewteen Inmon and Kimball philosophies
- Replies: 1
- Views: 1233
- Fri Jul 07, 2006 2:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Its very urgent!!Please reply
- Replies: 28
- Views: 15749