DSXchange

ArndW wrote:yes, use two different sequential file stages

In two different jobs would be the best solution, in my opinion.

No, just a re-install - no uninstall necessary first.

Well, it that is what you are doing - is there no equivalent on the PX side to how you would approach this in a Server job? There you would simply change the Data element column value to XML and those kind of 'coversions' would happen automagically.

Kim, am I missing something? Won't that put some sort of basic boiler-plate description into all the jobs? I suppose you could modify it to pull the description from some sort of generated list keyed to each job that someone typed up, otherwise it's just plain old IMW - Iterative Monkey Work - that ...

It's going to be a manual effort in some fashion, as I doubt all 500 of your jobs will end up with the same description. Rather than going through the effort of a full export / edit / import, I've found about the least painful way to update job descriptions is via the Manager. If your double-click o...

Three zeroes as the quote character indicates that there is no quote character in the data.

If they matched, you wouldn't get that particular error. Presorting is pretty much the only way to have the Aggregator support that volume. It allows it to push rows through at each group change, rather than having to hold onto them all before outputting anything. It can be tough to track down issue...

I added a pre-exec sort which helped me go from 1.2M to 1.5 but when I added the sort order in the aggregator, it failed on this error "srcDmSalesRepCanvPerfFDeltaTrAgg..Aggregate_Metrics: Row out of sequence At row 60, link "toTempSrc" Row out of sequence" This means the sort order you declared in...

Have you purchased it? "It" would be the RTI/SOA Edition of DataStage. It will come with installation instructions...

...as long as you don't have one of the 'extended' views on, I believe that may disable it.

But is it possible to design px jobs on a HP-UX and then import, compile and run them on an aix? (same version of DataStage of course) Yes. Heck, you can design and run jobs on Windows and then export/import/compile/run them on UNIX. Biggest thing to worry about there would be operating system spec...

Tell us what you have tried and what didn't work about it. You should be able to pick up the XML file with a Folder stage (remember, only two columns), feed it to an XML Input stage to do the parsing of the second column and then output it to your target of choice. Have you read the XML Pack pdf doc...

Well... ok. Question time. Define what 'running continuously' means in this case. What status does the monitor show for the Transformer in the job - Starting, Waiting, Running? Do the row counts grow until you kill it, get to a certain number and then stop or do they never get off of zero? Does the ...

I'm curious why you are walking down this 'named pipe' path when it doesn't seem to be something you are familiar with? Is this something that you actually need to do, to make work or are you... experimenting? There need to be two processes involved when working with named pipes. One is the 'writer'...

Yes, just the act of doing a 'View Data' from the source OCI stage shows the data 'incorrectly'. So, yes, in the sequential file they are wrong as well.