DSXchange

I'd probably use Left(InLink.TheString,40) - since I think it's better "self documentation" - but only after consulting the business to obtain a business rule to govern the situation that Len(InLink.TheString) > 40.

Specify the field delimiter character as \x15 or \021

The three-argument version of Trim() will remove them.

Performance Tip
Initialize a stage variable to Char(0) and do not derive it. That way the Char() function is evaluated only once per run, rather than once per row.

SetNull() in Transformer stage, make_null() in Modify stage.

Use a Row Generator to generate test data. That's what it's for!

You can not do what you seek to do, without forcing the format (record schema) to be that of the target Data Set. Once you have done that, you can use a Funnel stage.

Don't have an answer to that, Keith. I usually use an Execute Command activity to execute hostname (which works on both UNIX and Windows).

Go into the Stage Types folder in your Repository and inspect the properties of each stage type. It will tell you there whether the stage is active, passive or other.

In both cases disable operator combination and re-run so you can determine which actual operator (stage) is having the problem. The message telling us that the combined operator controller failed is singularly unhelpful for diagnostic purposes.

Does just the Monitor get hosed, or the entire Director? Does it close, or simply lose focus? If it actually aborts, is there an error message (and, if so, what is it)?

That the number is near 2^31 suggests that somewhere an Int is involved. You need to report this through your support provider.

In particular you can Search the forum. This question has been answered a number of times, as recently as last week.

Validate is a run mode that does everything except process rows. It opens files, establishes connections to data, gets SQL prepared and so on.

I find it a useful thing to do to test that job parameters work properly after deploying to new environments (such as test or production).

If they don't use the same format, what is the structure of the target?

The solution will probably involve two jobs, or two streams of activity within one job if the target rows are independent.

You've marked the thread as Resolved. How did you solve it?

Of course using an Oracle sequence is a possibility. However, there is a risk of introducing a bottleneck if the sequence is not set up to deliver blocks of values.

But the Original Poster seemed to be asking how to use (initialize) the Surrogate Key Generator stage.

OK, we've proven that the SQL is being passed to the job successfully. The next step is to establish that the SQL is being passed from the job to Oracle. You will need to enlist the help of your DBA to monitor the connection and record the SQL that was actually received by the Oracle database server...