Search found 175 matches
- Tue Aug 06, 2013 8:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hashed Pre-Load: both DATA.30 and OVER.30?
- Replies: 2
- Views: 3447
Hashed Pre-Load: both DATA.30 and OVER.30?
When a hashed file is pre-loaded to memory, is just the DATA.30 loaded or is the OVER.30 included as well?
- Thu Apr 15, 2010 2:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: More than 9 active oracle connections in a datastage job
- Replies: 1
- Views: 3314
Re: More than 9 active oracle connections in a datastage job
2. Also, could anyone suggest the pros and cons of placing all the extracts in a single job as against having 10 ETLs, one for each entity? The only pro I can think of in a design like this is that you have fewer total jobs. You have 1 job instead of 10, some people are annoyed by many jobs, so it ...
- Tue Jul 24, 2007 3:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Type 30 Descriptor Table Full - Windows
- Replies: 5
- Views: 4936
If you don't believe that you are using that many hashed files, remember that most of the Repository tables are also hashed files. Every job you create engenders some more, such as RT_CONFIGnn, RT_STATUSnn and RT_LOGnn. T30FILE sets an upper limit on the number that can be open simultaneously: the ...
- Wed Dec 28, 2005 1:02 pm
- Forum: Data Integration
- Topic: fact table
- Replies: 9
- Views: 30571
I have seen factless facts used mostly to report on all salesmen regardless if they have sales or some simliar concept. This way you can see the salesman has no sales for a given time period and the reports will reflect that. Otherwise the salesman does not show up at all on the report. Kim or Mike...
- Wed Dec 28, 2005 12:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Ignoring Duplicates while reading from Seq File
- Replies: 13
- Views: 8576
I agree with this, and that there is no need to go to a database table here. Obviously the RowProcCompareWithPreviousValue method worked for you, and I also think the other idea involving sorting and then writing to a hashed file is a good one. The ability to have a primary key on the hashed file is...
- Mon Jan 10, 2005 3:28 pm
- Forum: Site/Forum
- Topic: How would you like to see the DSXchange cover its costs?
- Replies: 13
- Views: 16466
Dan Marshall said that the site's most valuable asset is the people who collaborate here. This is definitlely true. The ability of the community to help you resolve your problem in a few hours is certainly the best asset. I guess that's also what makes it hard to sell/ rent/ charge for/ etc... this ...
- Mon Jan 10, 2005 9:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: performance issue
- Replies: 8
- Views: 6259
- Mon Jan 10, 2005 9:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Excel sheet
- Replies: 2
- Views: 2846
- Mon Jan 10, 2005 9:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Version Control and number of jobs in a project
- Replies: 3
- Views: 2840
I've seen a VERSION project as big as 5200 components and am working with one now that has 2300 components (mostly jobs) and it still performs fine. A common best practice though appears to be on occasion creating a second project called VERSION2 or VERSION_ARCHIVE and exporting VERSION to that one ...
- Fri Jan 07, 2005 11:32 am
- Forum: Site/Forum
- Topic: How would you like to see the DSXchange cover its costs?
- Replies: 13
- Views: 16466
thoughts: 1) it certainly weren't hurt to have a donation jar (Paypal, or similar) regardless of the final decision, hopefuly those that use the forum frequently wouldn't mind donating a little, especially those that have found their next position via the site. 2) My guess is it would be hard to get...
- Thu Jan 06, 2005 8:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Project Directory Growing Big
- Replies: 10
- Views: 7330
You also need to get your data and intermediate files out of the project directory and into a dedicated data directory. Are you using the localhost account to store your hash files? Are you writing intermediate files to a subdirectory of your project? Put all files and hash files used by the jobs i...
- Thu Jan 06, 2005 8:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Project Directory Growing Big
- Replies: 10
- Views: 7330
Re: Project Directory Growing Big
A hint: backup your project. Delete the jobs, reimport them and reschedule them (if that's required for a development environment). The problem you're probably having is that the project log hash files are becoming too big as they only grow and never shrink. Ogmios. is there a technical difference ...
- Wed Jan 05, 2005 3:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mapping new drieve
- Replies: 8
- Views: 5432
- Wed Jan 05, 2005 12:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: job control hard coded
- Replies: 1
- Views: 4404
I think your question is a little vague or hard to understand exactly what you want to know... please rephrase and clarify. I'm wondering if you are looking at the control logic here and are curious about what this developer has done versus what the default job control logic created by DataStage is,...
- Wed Dec 22, 2004 11:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How long will DataStage still live?
- Replies: 14
- Views: 8804
PX is the future platform, not Server. It's only a matter of time. I sure hope they make it more friendly before they bury Server. The Designer stages are, IMHO, unfriendly and unwieldy. The job designing is arduous, whereas Server is so easy to use. I think once the Windoze version of PX is releas...