DSXchange

The answer is different with different database products, and you left out the possibility of "none". Most usual, I guess, would be a b-tree index. But there are certainly other possibilities. And in some cases it is possible to change that decision subsequently. For example in Red Brick i...

For a star schema? No.

Maybe, by denormalizing the dimension. But, if so, why have the snowflakes in the first place? When's the interview? Actually, a better answer to this question is always "yes", if one is happy to ignore questions of efficiency. For example the holiday table associated with a time dimension...

So, 100 PVUs @ $289 per PVU = $28,900 for a single-core single CPU machine.

Close Director.

Minimizing Director comes close. But it's not as good as closing it.

Yes I'm serious. Every Director refresh is effectively a request back to the server to "stop what you're doing and give me an update". If Director is not running, these interruptions don't occur.

No, it's just that they use ActiveX and therefore are exposed via OLE servers and therefore can be seen by any Visual Basic variant. While you could use them (look at the documentation for UniVerse Objects for examples of how to use DataStage Objects) it's not for the faint hearted, and definitely n...

Not a whole lot. BEGIN or END followed by anything other than " SUB" should do it to differentiate each component in the DSX file.

Yes you can; in a trigger expression it's clearer to use OR conjunction.

Check with your DBA. Even if technically possible it may not be politically possible at your site, in which case you will need a management regime emplaced to change your password before the interval at which warnings begin to be generated.

Don't use literal constants ("1" : @VM : "2") - these values may change in future. Prefer DS Constants (DSJS.RUNOK : @VM : DSJS.RUNWARN). There's no "best" - you do what's right in each case. Some exceptions at your site, Scott, require email to be sent. So your decisio...

A look at how PX jobs in Ver 8.x can handle SCD type 2 http://www.leverageinformation.info/myAccount/techTips?techtip=wsdatastage WARNING This website (leverageinformation.info, not DSXchange!) is for sale and, apparently to try to make a buck, every page you touch opens an extra advertising window...

"They" also say that you can't install the server on Windoze XP.

Ok. IT IS NOT POSSIBLE.

You can not have your cake and eat it too. If you have to "specify" keys then it is not "generic".

If you intend to supply key fields then suddenly things are no longer "dynamic" or "generic" in terms of metadata. Had you given any thought as to how you will be "supplying" keys? Metadata can not be affected by job parameters, at least not directly.

1. Restore all three from backups, removing or renaming the broken ones first. It will be faster than attempting repair. 2. Find out who (or which application) writes extraneous entries into, or removes OVER.30 and .Type30 files from, dynamic hashed files. Explain things to them with sufficient vigo...