DSXchange

Solving the 'not able to see' problem is quite easy, but I'm sure you're aware of that. Post your SQL attempts so far... did you search for OLETYPE? If you've been diligent with your metadata, Usage Analysis can help as well.

Faulty expression... your 'or' should be an 'and', otherwise 59 <> 60 and 60 <> 59 so everything goes down it.

... and then use the Remove Duplicates stage to retain the last record per group.

Stage variables to do group change detection and concatenate the 2nd column within a group. Then the Remove Duplicates stage set to retain the last 'duplicate' will give you what you want.

This isn't about "special characters" but rather sending nulls to a required (NOT NULL) field. Stop doing that. Check the field for null and supply an appropriate default instead.

What database? And this "load_ind" - is it a control record in another table such that you only set it once per load or something else?

No. You have to repeat "-param" for each parameter/value pair on the command line.

Did you ask your official support provider?

You can't simply move dll's, as noted they must be registered there as well. This is normal Windows stuff, a quick google will get you the gory details.

No. Create NLS_LANG as a user-defined Environment Variable in the Project and set it to $ENV. Then add it to your job and override the default value there to whatever you need it to be.

You'll also need a VOC entry for the RESIZE command, so that means either an account-based hashed file or manually creating / dropping it. Search for SETFILE here for the syntax, if needed.

Hmmm... I would use Convert() for that.

Convert('"','',InLink.ColName)

There is no relationship. Think of 'node' like a 'thread' or process. Of course, the CPUs run the threads but it's up to the O/S to assign them and it could run all four on one or assign one to each CPU or any combination in between.

To me, the most important things which needs to be taken care of are backups - make sure you have both a full export of all projects and a filesystem level one as well. The actual upgrade is "in place" and should be fairly painless.

:? Right after I posted this I realized you weren't trying to emulate the 'insert else update' action the stage can do for you but rather than delete my original post (which has valid information in it) I decided to leave it and add this instead. Two separate actions would use two links. They can bo...