DSXchange

Ah... DSMigrator. Probably not something they allow "out of house", I would think.

This post should help.

DSMigrate = Directory Services Migration Tool for NetWare. As Ken notes, Google is your friend.

In Oracle, when you insert data into a table and do not mention all of the fields, the ones that are not mentioned get default values. Unless you override them in the DDL, the default value for all fields is a NULL. This doesn't work out so well when the fields do not allow nulls. You'll need to add...

this works only if have some previous records has the same record where look up succeeds, but it does't work for my current load. Sure it does... or at least it can be made to. You need to write to the same hash file you are doing your lookups on when the lookup fails. That way, if you have duplica...

Welcome!

If I'm following you, all you need is two output links and the proper constraints so that the second one for the 'void' record is only used when the lookup succeeds.

Let us know if you need more help than that.

PhilHibbs wrote:The Sequential File component does not appear to be capable of processing a file that does not have line terminators

Sure it can. Set 'Terminators' to 'None' and then ensure your Display metadata is correctly sized.

Unless they are running on Tru64.

Exactly. The OP specified "Server" as the job type, so it doesn't really help to give PX specific answers. Besides, there's a different forum for Parallel jobs.

Nope.

Oracle timestamp format: YYYY-MM-DD HH24:MI:SS

At least that's what the OCI stage is expecting.

Very interesting, Vincent. Old dog learn New Trick.

Hopefully this is one of those "undocumented features" that continues to work in future versions.

While I can't help with the specific error you've posted, I'm sure you could resolve the issue by switching to OCI over ODBC. I really don't understand why people use ODBC when native drivers are available. Is there some particular reason why you must use ODBC in this case, or can't use OCI? Stored ...

Can't say I've seen your 'not finishing' issue. I'd start by reporting it to Ascential support and see if they can shed any light on it. Does it matter how many instances you run at any given time? Well, when it says that the Disk Cache Subsystem is limited to 512MB, I would think you'll need to fin...

Take a look through the Transforms that come with the product. For example, there is one called DIGITS that removes all non-numerics from a string. I'm sure there's some sort of alpha equivalent as well. Just checked and there is - it's called LETTERS . Looking at them, you'll see that they simply i...

You could take a look at building a Routine, one that leverages the DSGetJobInfo function. One of the 'gettable' items nowadays is the Invocation ID. So, possibly a custom routine that takes the filename as input and sends it back out with the appropriate ID worked into it? You could also look at us...