DSXchange

No, it has everything to do with your reference lookup, I would wager. Each record does a singleton select across the network to your db. How efficient is your lookup sql? Not nearly as efficient as a hashed one would be.

You can always install it. It will validate your values every time a job runs and let you know if it thinks you are out of compliance. The VM instance will only see 4 so you should be fine unless they are dual core.

In your shoes, I would check with your official support provider to see if this is a known issue with 11g.

parag.s.27 wrote:so here there are two spaces between "Riverbank" and "Road" so Trim removes one space. That is a known issue for which workaround seems to be to use TrimLeadingTrailing().

As noted, this is not a "known issue" but rather is documented as part of How It Works.

There are at least a couple of posts on this subject that I've participated in, one is titled something like 'When is a null not a null?'.

Sounds like a connector version of the DRS stage.

When you launched your 'dssh' command, did it tell you something along the lines of it not being 'properly set up' and asking you if you want to set it up? If so, the answer is always no. This means you are not launching the command from the proper location, which would be either the DSEngine direct...

Make sure you know where your bottleneck is, lookup or target. And your reference lookup should be to a hashed file not directly to a database table.

You need to provide the count you are licensed for regardless of what's actually on the server you are installing on. Virtual or otherwise.

Then you should mark your post as Resolved using the button at the top of the page. Please.

Or that.

Locks.

You can't view an old Webinar AFAIK but their information should be available from the 'Downloads' links posted below each one.

Not wanting to derail the thread but what exactly is this tool?

Figured it could, just never seen it.

Any such lock would foil the export/import trick as well, I would think.