Search found 23 matches
- Mon Feb 07, 2005 11:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: What is advantage of taking data from table into hash file?
- Replies: 2
- Views: 1738
Akash I am sure this is covered in numerous previous posts. However, it is always worth repeating. In addition to what has already been mentioned, a table is usually copied to a hash file for performance advantages when doing lookups. If a large number of look ups are required on a dataset that is s...
- Mon Feb 16, 2004 8:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UV Stage
- Replies: 4
- Views: 2737
- Tue Dec 09, 2003 2:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Call Java function from Datastage Job
- Replies: 7
- Views: 4910
Under the DSEngine directory on unix you should find a directory called unishared.load/uojsdk/lib and this should be included in your classpath for java. There are sample programs and some documentation in the subdirectories of unishared.load. There are java equivalent methods for most of the Basic ...
- Mon Dec 08, 2003 10:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need help to success in interview
- Replies: 19
- Views: 8502
Kim I agree with all you say, and also with the substance of what Ken was saying. I certainly don't judge all Americans by the few. I have met some bad examples but I have also met loads of Americans that are great folk. Some of my comments and examples were meant light heartedly. Certainly in the U...
- Mon Dec 08, 2003 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need help to success in interview
- Replies: 19
- Views: 8502
[America is the most creative country on the planet. I have seen a lot of very smart Indians and other nationalities struggle to compete in this environment. ] True America is creative. True many jobs from America and Europe (where I work) are going to India and other places. That's the democratic f...
- Mon Dec 01, 2003 2:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How effective DataStage EE on 4 CPU system?
- Replies: 10
- Views: 3485
To get the most from a 4 CPU box it is worth switching on inter process row buffering from the Performance tab of the Job Properties. This can provide dramatic performance improvements depending on the job design. If you use this option be careful to check that your job still works as expected; glob...
- Wed Nov 19, 2003 4:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup - No of Rows returned
- Replies: 14
- Views: 7745
- Wed Nov 19, 2003 4:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: unix connection error
- Replies: 8
- Views: 4242
On Solaris platform there is a master uvodbc.config file in the datastage home directory and there are also project level copies in each project directory. Make sure the correct uvodbc.config is gettign picked up. Also double check that the dirver specified really does exist and is readable. Paul Pr...
- Thu Oct 23, 2003 10:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Writer - double slash
- Replies: 8
- Views: 3665
Indeed the double slash does not what you hoped. We do not have tags coming out of our UV tables any more. We let the XML writer generate all the tag information. Tags may repeat several dozen times in our output XML files but we separate invoice rows, invoice addresses and other relationships out t...
- Wed Oct 22, 2003 10:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Writer - double slash
- Replies: 8
- Views: 3665
- Wed Oct 22, 2003 4:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Writer - double slash
- Replies: 8
- Views: 3665
Some columns after invoice rows are optional. As I said in the first post, invoice rows are already in XML-mode and I read them from UV-stage with multi row result set. We also use a UV table with multi row select, and we have similar output. I will check the definition later this afternoon and tel...
- Wed Oct 22, 2003 2:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Writer - double slash
- Replies: 8
- Views: 3665
Hi Petri are you using the XML 2 pack or the standard XML 1 writer? It would be nice if you could post a section of how yuou want the output to appear. Are there any optional fields that are sometimes missing? We put most of our data including invoice data ito XML and it works very well so post up a...
- Mon Oct 20, 2003 3:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unix Security and Job Compilation
- Replies: 16
- Views: 5148
- Fri Oct 17, 2003 4:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Executing a stored procedure in after sql
- Replies: 3
- Views: 2217
- Thu Oct 16, 2003 6:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01306
- Replies: 6
- Views: 3247
Hi you mention that this query is in a lookup. With no bind variables (:1,:2 etc) the same query will be executed for every row in your source data. Lookups with user written queries usually include bind variables. If you have a user defined query with no bind variables and you expect that the recor...