DSXchange

I don't. While my first answer was somewhat facetious, the second was serious. A loopback is something that plugs into the port to just send the same signal back in that came out, a way to trick a process that thinks it needs to have that port connected. Sorry, not aware of what the setting changes ...

That's to sign up for the webinar, click on the download links instead. I believe they are free now but will probably at some point become Premium only, from what I understand.

What is a "working" date? Do you need to handle holidays as well?

Either leverage an existing Time dimension or convert the date to the first of the next month and then subtract one day from it and see if that is a "working" day. If not, keep going backwards until you hit one.

Is the Oracle target a DATE or a true TIMESTAMP? Is your target DML using a TO_DATE() or TO_TIMESTAMP() function?

How can your target column have a variable length? You 'zero pad' and right-align something to a fixed length. Either hard-code the length in the FMT function or explain why you can't.

That is not how you quote someone. Did you Preview this before you submitted it?

What happened when you clicked on the link?

Use the second TO_CHAR() without the TRUNC() as it is unneeded and declare the output field as a varchar(10).

And?

Talk to the System Administrator responsible for the box. That can't be you.

Plug the cable back in? Get a loopback connector?

What do the jobs that do not run have in common? What is different between them and the ones that do work without error?

The External Source stage should just be passing in just the filename and the XML Input stage therefore is the one doing the reading. Yes?

In order to do that, your string value would need to be quoted otherwise your file is invalid.

10|"MUM|BAI"|MH

Would read correctly. Otherwise you'd need to read it as a single string and then (attempt to) intelligently parse out the fields in a transformer.

Don't run out of disk space where anything DataStage is installed. That's the number one cause.

No, not really. The only 'conditional execution' of this kind that you have control over is at the link level via constraints. However, when a constraint equates to false such that nothing is passed out the link, the derivations in the link columns do not 'fire' as well, so perhaps you could leverag...