DSXchange

chulett wrote:Short answer - no. One of the joys of using a standard 'widget' for an interface, not all fields apply to all stages.

Outstanding!
Thank you.

I can live with the "hand-me-down" ui widgets.
It is not knowing which bits are relevant
that makes me crazy.
John G.

Does "Derivation" actually do anything for XML Input PX stage? I ask because it isn't mentioned in the "XML PACK" (XMLPACK_20_Designer.pdf) docs and doesn't seem to have many posts in the PX-forum here. Anyway, XMLInput statge, Output tab, Columns has the following table: Column ...

How similar is "very similar"? Like, "Basically the same job w/hundreds different sources (non-matching schemas but a similar purpose) that map to a single target schema?" What drives your mappings, e.g. manually launched? Batch schedule? Real-time? It would be easier to specula...

(a) you appear to have "=" rather than ":" after the drive letter (b) the pathname should be that of the control file; that is, end at ".ds" RW, that makes sense. While I would swear I saw path-names somewhere (like in KSH or OSH) using C=/whatever (instead of the norm...

I wonder if setting these env-vars in your job would let it run? APT_BUFFERIO_NOMAP=1 APT_IO_NOMAP=1 The memory-map idea is a great performance booster, but if your nodes are very busy, there might not be that much memory available. Or, as Ultramundane suggested, changing your kernel settings to hav...

File Pattern : acential/datastage/folder/xml/data/*.xml Read Method: File Pattern Rajan.n had a good idea, try changing your file pattern to be absolute, e.g. start with a leading slash. Unix might be: /acential/datastage/folder/xml/data/*.xml Windows might be: C:/acential/datastage/folder/xml/data...

I currently speccing an environment where the transformations run 24x7 on a DataStage grid but the database load should only occur overnight so you don't impact the users. One method for doing this quickly is to take a copy of the target table into a dataset overnight and use it for processing duri...

Has anyone run into a real-world case where ChangeApply stage was helpful? I understand what it does, but I'm struggling to think of a case where I would want to use it. The only thing I've thought of so far would be a storage-optimization, so I can keep change-sets on hand instead of individual &qu...

It's correct. Logic is left to right where there are no parentheses. So the two AND operators will have been evaluated before it gets to the OR operator. (Optimized it may not even get to the OR operator if one of the preceding conditions is not true.) Ok, that makes sense. Thank you. *sigh* What w...

Here's an example from (parjdev.pdf) Parallel Job Developers Guide. I'm wondering if the docs are accurate? Filter Stage 29-5 ( p.682) -----begin excerpt----- Evaluating Input Columns You want to evaluate each input row to see if these conditions prevail: * EITHER all the following are true - Column...

Well, good luck! My unix introduction was painful :) I trapped myself in the "cat" command (had to reboot the machine to get out of it!) I've learned a lot since then. If you're doing this on windows, go get a program call VIM (vim.org) - that is better than the "vi" includes. Sp...

Currently, my cofiguration is set to 8 nodes on a 16 CPU system (SMP), it has a SAN and all my disk and scratch space is set to fs_stage_dataset/Dataset or fs_stage_dataset/Scratch. We have issues like SIGKILL, SIGBUS and these are due to resource constraints. One of the frequent errors that we hav...

I'd do a KSH script like this... thum's for file in * one looks fine, too. Depending on how I set the loop up, the files would expand (glob) at invocation time so it had an empty list to chew on - hence the find in mine. I like the date format %Y%m%d, which generates 20061004. "man date" w...