DSXchange

Sort your incoming data before the transform stage by descending filename. In your transform use stage variables to only pass on the highest (first) filename records SvFirstFileName IF NOT(SvFirstGroupName) THEN In.Filename ELSE SvFirstFileName Constraint: In.FileName=SvFirstFileName This will only ...

Can you use your explorer and connect to "http://yourserver:9080"?

vijairv, we think (well, actually we know) that you deleted one or more necessary files in your cleanup action and it is unlikely that the project can be saved. If you have an OS-Level backup you can restore the missing files. Otherwise your only choice is to create a new project and restore your Da...

Could you explain how it didn't work? Note that DataStage jobs don't do explicit COMMITs, once the row count or time threshold is reached a COMMIT is performed. If the job aborts an implicit rollback of the current transaction is performed.

In order to determine what can be done to "tune" this job, you need to establish some reference values first. Start off with just your source OCI stage and write straight to a sequential file at /dev/null; i.e. a copy of this job with just 2 stages. What is your Rows/Second speed for this ...

If your output is a sequential file then I would recommend dispensing with a TIME datatype and just using a string, i.e.

Do you know if the server was very busy when you tried it? Also, I dind't quite understand from your answer if this problem always happens or if you can sometimes login successfully.

Assuming that the unsigned int will fit into a normal int then (a) you don't need to perform a conversion as the two values are identical at a bit level and/or (b) put in a transform, copy or other stage in your stream and remove the "unsigned" attribte from the output stream and you will ...

Stick with a sequential file output for the moment to simplify the problem. Do "Go" and "Mo" mean "gigabyte" and "megabyte" or something else?
How big is the output file when the job aborts?

I don't know what could be causing that offhand. Does it abort at exactly the same row each time (even if the data sort order is different)?
"600 Go" does that mean Gigabyte?
What is your output stage after the merge stage?

Will do what you wish.

There are many ways to do this. What is your target? If it is a database, the simplest might be to do inserts only and have it ignore updates. In that case, you can re-run your job and the records that have already been inserted will be skipped. You will need to explain your environment a bit more i...

Instead of the '2010-11-18' value that ray suggested, use $Starttime.

A quick Google search shows that the ORA-0900 error has more to do with the call than the procedure itself. Have you tried using double-quotes instead of single quotes in the call?

Did you add a semicolon at the end of the command?