DSXchange

It's useful to remember that collection will only occur if the upstream operator (the "producer") is executing in parallel mode and the downstream operator (the "consumer") is executing in sequential mode. Partitioning occurs when the consumer is executing in parallel and the alg...

I expect that this is a non-default timestamp format, which you should be able to resolve by providing the correct timestamp format in the metadata (whether that's in the job or in a schema file). The import operator is looking for the trailing quote character or a timestamp character, but found &qu...

When's the interview?

Welcome aboard.

There are many Orchestrate operators. Which one did you want to know about?

When's the interview?

Try exporting some terms and categories that include related terms and examine the format of file that BG generates (and therefore expects when import is occurring).

Yes, that was the one.

Can you log in to Web Console for Information Server?

Have you confirmed that the services tier, the agents and DataStage were successfully started?

I vaguely recall that there's a /Y switch that says "answer all questions with Y". If there isn't you can use an old trick, to redirect NUL to stdin, thereby supplying an infinite supply of "Enter" presses. dscmdexport /D=domain /H=engine /U=user /P=password project filepath /V <...

Information Analyzer (8.1.2 or later) has a matches_regex data rule available. It would be interesting to inspect the osh script that is generated from a data rule job that uses this, to see which operator is invoked. Alas, I'm not currently in a position to do that.

There's nothing out of the box in the parallel Transformer stage for searching for multiple string. Matches (in a BASIC Transformer stage) would do it. Or you could write your own parallel routine. A probably slower option would be an External Filter stage, that could use regular expressions to repo...

Let the metadata define the scale. The documentation for DecimalToDecimal() says that the arguments are: thevalue (decimal) rtype (string) packedflag (int8) So it's found your 2 when it expected one of "round_inf", "trunc_zero", ceil" or "floor". Try DecimalToDecim...

Can you please post your actual derivation expression?

Is this in a Transformer stage or in a Modify stage?

Try Div(7,3), Mod(7,3) and 7/3 and see what you get in each case.

Perform an internet search for the term "integer division".

Head stage (N rows) followed by Tail stage (1 row). There's always more than one way. Note that, in parallel execution, any of these methods will give you the Nth row on each node.

OK, the exception is "connection refused". This could be incorrect user name and password, it could be that the user name you are using is not actually registered within Information Server with at least Suite User role, or one of a number of other possibilities. Please check the correctnes...