DSXchange

No stage can report how many were actually inserted/updated. They can only report how many they sent. You can also get a count of rejects (which the Oracle Enterprise stage can do).

Yes, but not until you upgrade to version 8.1 in which you get both a resource estimator and also a performance analyzer. And, alas, they only work on parallel jobs.

So, probably, no.

Resist stupid requirements!

You should never have to abort a job.

Yes. Try it.

Please re-read my question. Then answer it. Or at the very least try to think about what I'm driving at.

Exactly the same error, referring to a length of 5? If so, you've missed one - or are looking at the wrong log.

Hmm. Brave call. Do you have any evidence/documentary proof?

I admit that I have not studied the API documentation in sufficient depth to have answered this question.

Search would reveal not only the meaning of -14 (which you seem to have discovered) but also the fact that the status reported in Director is not always the real status of the job.

They are called job parameters. Job parameter references can replace any constant in an SQL query. Others have experimented with replacing the entire SQL query with a single job parameter reference for total customization, but here you need dynamic metadata management, such as is provided for by use...

That's not what RCP does, so no to that question. There is no automatic mechanism of which I am aware; put simply your data do not match your metadata (record schema) in all cases. Only one format can be specified for any single date field in a record schema.

I'd be more concerned about why a collector is being inserted. Which stage types are executing in sequential mode, and why?

If this is a decimal data type, the leading zeroes (and trailing nonsignificant zeroes) are emplaced to fulfil the requirements of the precision and scale settings. Search DSXchange for more information on this behaviour.

You don't. You can define it as string, then bring it into a standard format (for example by adding leading zeroes to day and month where required) before converting to Date data type.

But U (one of our posters) probably is disinterested in doing so.

The second person personal pronoun in English is spelled "you".

I, for one, will avoid answering interview questions here. I have given my reasons for this decision in the past; you can search for them if you wish.