DSXchange

jwiles wrote:Sometimes questions will go unanswered...that's the nature of this type of forum. We're all volunteers and answer if we have time and answers that might be helpful.

Exactly. Unanswered, perhaps. Unnoticed? Not a chance.

Can someone tell me where to set the configuration file (apt) for a the job? As noted, you'd need to have added the $APT_CONFIG_FILE variable to the job, that would give you the ability to override it and have the job point to the single node config rather than the default two node config. There ar...

Can you tell by the filenames if there's a certain stage or activity that is creating files in /tmp? I'm not sure what Parallel processes would create ade files. I've seen them in the past generated from the shared memory segments RTI/ISD jobs use and also from Server jobs with IPC stages. Assuming...

I don't believe so, try it and let us know.

How is this any different that your previous post asking the exact same question? (hint: it's not)

Please continue with any questions you may have there as I'm locking this one.

Setting "NO SORT INSERTION" to true means it is not allowed to insert tsort operators. Same goes for partitioning.

You need to ensure the data is sorted properly to support the aggregation being done.

I don't see a burning need to stage everything first and would probably just suggest you load them directly. However, is there RI between the target tables? That would complicate things...

I'd look at doing the detection in a Transformer. You'll need to recognize the section you are in and then control your outputs via constraints. Stage variables would help with that. Each section specific output link could then use a Column Import stage to parse them. What's the bottom line here, ho...

Just for the record, I have a pet peeve - when someone calls out specific people when they post. There are upwards of 30,000 people registered here and any one of them can help.

Also, have some goram patience. You posted at 1AM my time and then at 4AM bumped it again. Sheesh.

Did you research what exactly a ORA-04091 error is? Have you taken the error to your DBA? It generally means you have a trigger on the table and the trigger is not written correctly. See some examples here.

The PX Sequential File stage is quite militant about file structure and I'm not sure there is a way to handle that with the properties it has. A Server job would handle that quite easily, however. Be curious what others say. For PX, you may need to read the file as one long string and then parse the...

Refer what there? There's an awful lot of information on the site and I for one can't find anything to back up your assertion. Do you have a more specific link you can post or perhaps a specific example?

xinhuang66 wrote:

chulett wrote:As noted, the PX product ships with the MKS Toolkit which allows emulation of UNIX under Windows.

MKS is not shipped with DS Server version. Am I right.

Correct... but that doesn't mean it can't be purchased.