DSXchange

You're on Solaris 2.9, so use prstat -a from a unix command line to monitor server process and load. DS jobs show up under "phantom" processes. If you have 8 cpus, then a fully utilized cpu by a process shows as 1/8 or 13%. If the sum of user processes (the -a option shows top 5 user summary at the ...

From the transformer immediately in front of the ODBC stage simply add another output link per your DS manual (please read it). Simply set the constraint to have the reject box checked, and make sure the link is the last one in the execution order. Rejects from the database will come back to the tra...

What are you talking about?

Add a second output link to an aggregator stage to do whatever totalling (SUM), counts (COUNT), you need to do. Group by the appropriate columns, or feed a column to just cause everything to group to one row for a grand total.

If someone did an "rm" inside the directory, the .Type30 file must have disappeared. If the data is not persistent, you should remove the hash file and recreate it as needed. By the way, your performance with this hash file has to be terrible.

Oracle allows CASE in the columns, group, order, and where clauses. The CASE construct allows you to do IF-THEN-ELSE, just do it on the WHERE condition. WHERE conditions either are used for joins or for filters. In your situation, it's a conditional filter. If you have ToDate parameter value specifi...

There's no replace, but thru substring manipulation you can achieve the effect:

What do I have to change in the DSX-cutter Steve posted the program to share with the global community. If you would like it customized, you can send an email to Steve. The reason we didn't put executables into the cutter is because sometimes you lose synchronisity between source code and executabl...

Actually, there is a server side export version as well.

If the target table is partitioned, and most of the partitions are finished and committed when another partition fails, then you can't rollback.

You'll have to delete the rows.

Reading or loading using a view removes any application from directly accessing the underlying data. Because the view is a virtual table, there is no information about the physical table partitioning, so any tool won't be able to rewrite its query to include directly-named partitions and use the sam...

Thank you for the inputs. As the hash file size limit is 2GB and in the UAT environment I have 24 million records and it could be more in production. Will the hashfile handle this big? thanks Without a doubt, spooling data into a hash file has significant overhead as compared to a sequential file. ...

I have a utility that compiles jobs and one for routines. I'll look to see if it's posted on this forum, otherwise, it's availbable for download on my company website user area.

Your problem is not the sequential stage. Your problem is that you have a single-threaded job design that will only use a single cpu to do its work. If you have 6 cpus, you could use 6 instances of your third job to each handle 1/6th of the source data. In theory, you would scale your throughput up ...

kiran_418 wrote:what is the ADN website

www.ascential.com