DSXchange

Okay, enough fun. Each hash file has a maximum size that can be cached, once the file at preload time exceeds that size you get a message telling you that the file is too big and it won't preload. As for write delay, that's the maximum that can write delay until it has to start writing to disk. You ...

netland wrote:Does my job allocate 50*128MB

No

netland wrote:or only the total size of the 50hashfiles, but with a project maximum of 128MB ?

No

netland wrote:Is the 128MB allocated for ALL hashfiles that are cache enabled.

No

netland wrote: or is it a maximum for each hashfile

Yes

netland wrote:each job or the project ?

No

Use custom designed job control to not only run jobs, but gather all process metadata during/after the run and update your audit repository realtime.

You fully qualified the schema name, so you can't be getting fouled up with a local vs public synonym issue. I can't really help you much more, maybe someone else has an idea.

Views/tables, doesn't make a difference.

If the same query in Toad returns data, you need to verify the connection string. Make sure you're hitting the right instance, because your Toad connection on your PC could be using a different tnsnames.ora file than the DS server.

I was able to convert all the account setting to directory setting editing the dsx file. This is your mistake. You need to use the project setting, as it will then pick up the VOC entry created by SETFILE to file the path to the hash file. The SELECT tab is only activated for jobs with the project ...

Because that's not how it works. What it does is allow multiple rows to be in transit across a string of active stages between two passive stages, as opposed to a single row having to make it all of the way across to the second passive stage before the next row can start. Your job is working perfect...

The "base" job is what you design. Under Job Properties you enable multi-instance for that job. When you compile/import the base job, all instances are deleted. You cannot edit an instance of a job. When you run or validate a base job, you are given an additional field to supply: invocation id. When...

First, your desire to not use a transformer stage is irrelevant, because DS Server will still create a transparent one anyway to do what you want, you're just losing a lot of functionality and ease in building your job design. Your requirement is a poorone. If you're talking about OCI-->OCI job desi...

Because of partitioning and varying loads on each node, the last row in the source file may be processed ahead of previous rows in the file that went to slower nodes. This is true all the way up until you hit a stage that forces the rows to be sorted again back into their original order, which is a ...

Is there a reason why you couldn't use the OCI stage's truncate then insert option? Mike Truncate requires a high level of authority, you actually have to have alter table permissions. Some DBAs are unwilling to give out that access so the native TRUNCATE statement can't be used. You can force your...

Use the unix program "head" and specify how many lines from the top of the file you want. Alternatively, "tail" gives you lines from the bottom. You can make any size file you want.

Only thru a reverse-engineering effort, Ascential does not provide for that in any of the client applications. I do have a free utility job for doing so. You can get it from my website after applying for access to the members area. I may have posted the logic here on the forum as well, so take a qui...

I cannot for the life of me figure out why you would want to do this. Can you please explain what your problem is, maybe we can give you a better solution. Your answer to your posed question, unfortunately, is to load whatever data you have created into a table, and then kick off a stored procedure ...

Is there any way through which we can find in our project that which job is using left/right outer join in source DRS TO a particular table, or just any job doing any outer join? Which database are you talking about? The syntax can vary depending on the database and developer. How are you judging a...