DSXchange

Some questions: - The stage is parallel? - Partitioning is resulting in relatively even balance of rows across partitions? - You're not performing an in-line 'pre-sort' on the input link are you? (I've seen this in many places) - Have you considered playing with memory usage? ($APT_TSORT_STRESS_BLOC...

Are you using single quotes around your APT_CONFIG_FILE value? Try removing them.

Maybe there's something in here?

http://www.redbooks.ibm.com/abstracts/sg247402.html

A simple solution would be an after-job routine which used DSGetJobInfo to get the information you require. You could then fire this at Oracle using your preferred method.

My guess is these are orphaned (dropped) connections - those where the client is no longer connected but for which the server-side daemon (dsrpcd) is still present.

Hi Josh, there are a number of approaches to duplicate checking, and the one you take depends upon the context in which your processing is taking place. For the code you quoted you're probably better using ... If IsNotNull(Src.A) AND IsNotNull(Src.B) AND IsNotNull(Src.C) Then Src.A : Src.B : Src.C E...

You could also check file locks with fuser.
E.g.

Sorry to bump such an old post but I'm having this problem myself. Can the O/P tell us whether they found a resolution?

Thanks,
John.

... or if you're averse to Craig's straightforward solution, or your requirements become more complex, then you could always use <a href="viewtopic.php?t=107882">regular expressions</a>

John.

I had the same issue and resolved it by a combination of re-compiling the jobs which used the modified parameter sets and/or removing and replacing the job activity on the sequence canvas.

J.

1. What's the objection/restriction around using Transformer stages?

2. Specify 'ID' and 'DT' as grouping keys and use an aggregation type of 'Count Rows'. This will count unique ID/DT combinations. Define a 'Count Output Column' and add a descending sort by this column.

Is there something about the design of this site that made you mistake it for a WAREZ site? Perhaps you should try one of the open source tools?

Crikey - Can you provide us with some more hints to go on? Can we assume the error is being generated by a Transformer stage? You say that you didn't have a problem before you "concatenate(d) the User defined variable", so in answer to your question about where you went wrong I'll chance m...

Assuming ... 1. By 'dominant' you mean 'frequent' 2. Your input data is sorted (as it is in your example) Without designing the job in its entirety for you, here are a few suggestions ... - Use an aggregator to generate a count of each DT value within each ID group - Sort and propagate the first two...

You can test your ODBC data sources from the command line: $> cd $DSHOME $> cd ../branded_odbc/example/example $> example This will prompt you for your ODBC DSN and connection credentials then provide a SQL command line where you can submit ODBC-compliant queries to your data source. John.