DSXchange

When a hashed file is pre-loaded to memory, is just the DATA.30 loaded or is the OVER.30 included as well?

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 ...

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 ...

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...

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...

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 ...

also, tell us what the job is doing in terms of row buffering, and if row buffering is on whether it is In-process or Inter-process. Or at least run the job with different settings in regards to row buffering and see what settings help/hurt.

Sidenote: The Excel question is probably another good candidate to add to our FAQ section.

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 ...

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...

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...

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 ...

Is this how the coding should look? Does it matter that part of the path has a space "FTP TOTE" instead of "FTPTOTE"? Call DSExecute("NT", "net use K: \\Secureftp\FTP TOTE /PERSISTENT:NO", msgs, rtncd) I'm not sure I can completely help you on this problem, b...

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,...

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...