DSXchange

Installation process is exactly the same whether or not the compiler is installed.

Of course you will not be able to compile any job that includes a Transformer stage, and you will not be able to compile any Build stage.

When did you move to RSA?

More particularly, as an ordinary poster I can not mark anyone else's post as Resolved or anything else.

Either you have not generated the match frequencies, or you have pointed the job at an empty data set using the match frequencies input link to your match stage.

That's correct. In an exam it'll be multiple choice, which should make it a bit easier.

Welcome aboard. Constraint expressions in the Transformer stage should be something like: IsNull(InLink.TestField) --> Insert Not(IsNull(InLink.TestField) --> Update An alternative is: IsNull(InLink.TestField) --> Insert Otherwise (check box) --> Update Note that DataStage does differentiate between...

You are correct. The score only ever reports player processes. However the exam question may well be interested in all processes.

Try excaping the backslashes.

Simply count the processes. [op0,p0] [op1,p0] [op1,p1] [op2,p0] Four player processes. op0 (SEQ_SOURCE) is sequential (one process) op1 (APT_CombinedOperatorController) is parallel (two processes) op2 (SEQ_TARGET) is sequential (one process) Four player processes. Because there are two nodes there a...

I think that's just "how it works" - Oracle throws an error if you invoke sqlldr and provide a stream of 0 records. You should check first whether any records will be selected, and only execute the job if there are.

You cannot trim a double-width character to make it smaller. It's called double width because it has so many strokes that it occupies more space than a regular character. (Or it's deliberately double width for the purposes of beauty in typography, such as the double width space.)

Welcome aboard. Let's start with stating that version 7.5 is a very old version now, and that only the client is supported on Window XP. To use Oracle you must have the Oracle client installed and configured (tnsnames.ora in particular). You can add environment variables as required using the Admini...

Have you properly installed Oracle client software on your DataStage server and configured tnsnames.ora (and, possibly, sqlnet.ora)?

Single. You can find it even in a 7-bit ASCII table.

That should be handled OK, provided you've specified that "" is to be treated as NULL.

My question is, does Datastage by default assume all varchars as varchar(40)? No. Usually, with NLS enabled, Oracle VARCHAR2(9) CHARS would be VARCHAR(27) BYTES or, perhaps VARCHAR2(36) BYTES, and that would be what DataStage imports, so I can't really guess where the 40 is coming from. Did you act...