DSXchange

Could you post the database metadata here - there are occasionally datatype issues where the type isn't loaded in correctly

A UNIX backup will have saved the state of the whole project as it was at the time of backup. If you didn't make any changes to any of the jobs in your project after the backup was taken, or if you don't care about losing those changes, then you can restore the whole project directory from UNIX. If ...

You can use your UNIX "rm" command to remove files in that directory. Nothing untoward will happen if you delete the open file for a running job - except that any information about the running job will be lost. I would use a filter on that directory that just removes anything older than a day to sure.

What struck me was "NT" as the shell, but the "MV" command in the original also had a keyword "TO"... quite odd. But posted in the UNIX bracket and using UNIX style paths, so most likely it is a UNIX command.

Wow - good job, DSGuru2B!

Actually, the &PH& project subdirectory can be cleared from UNIX, even when jobs are running.

I am not sure of thet syntax of youe "mv" command, as it is not standard DOS. Try this:

Anupam,

interesting - I tried it as well since, like Ray, I was sure it only used one character.

Unfortunately, it did not work for me; it only uses the first character and ignores any subsequent ones for the delimiter.

I suggest you check again.

The Webmaster is either still asleep at this time or getting his first 'cuppa (4am his time as of this writing). But I'm sure that if you e-mail him directly or post a thread in Site/Forum section is will get addressed immediately.

[quote="abhilashnair...Yes, I am the original poster of this topic...[/quote]
Sorry, but I had to ask. I wonder if this issue is limited to a single forum, since I've seen threads marked as resolved in the past couple of days.

Using the aggregator stage in this case will not really be necessary (or efficient). The method will depend on what the original poster needs this for. If this number of rows is needed from another job or sequence, then a call to DSGetLinkInfo() will get that value. But that method doesn't make sens...

This looks like a good and easy to reproduce problem to submit to your support provider; it does look like a difference in the C++ compilers between AIX and Windows. If you look at your generated source code and find the trim() function you can check it against the Visual Studio documentation.

Are you the original poster for that topic?

Does the file have 10 records? What is your grid configuration - how many nodes and how are they interconnected?

What is the bottleneck? Is your CPU for the transform stage at 90% or higher? Is Oracle on the same machine? If not, what is the network throughput capacity at?