DSXchange

Too much code. Constraint 1: InLink.KeyChange And LastRowInGroup(InLink.keycol) Constraint 2: Otherwise/Log No need to generate 1s and 0s - you're just wasting CPU cycles by doing so. I now invite you to inspect your code and YOU answer the question whether it meets the original poster's requirements.

You could use IBM developerWorks.
Or there are lots of blog sites, such as WordPress, where you would retain a greater degree of control over your own work.

It's a very brave assertion to make that whatever it is you have done is unique, so I'll be interested to read what you have to say.

Let's go back to the original problem. main_program: (aptoci.C:132). Message: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory You have an Oracle error code (-27101) and message, which means that you ARE connec...

Are you sure that LUTProcessOp isn't combined with some other operator(s) into an APTCombinedOperatorController?

The LUTCreateOp partitioning is governed by whatever is set up on the reference input to the Lookup stage.

Lookup stage ordinarily generates a composite operator consisting of LUTCreateOp and LUTProcessOp. LUTCreateOp loads the reference data into memory and builds a hash index on the fly, unless the reference data are in a Lookup File Set in which case the index was built when the Lookup File Set was cr...

I didn't ask you to re-install the whole Services tier - just the contents of ASBServer/bin - the things you deleted.

Can you connect, using the same information, with some other client such as TOAD or sqlplus command?

No. The SCD stage needs to load the dimension table into memory.

Imagine you don't have DataStage. Then, to check 200 columns, you have to do 200 checks, yes? Why do you think DataStage could do it any differently, particularly of the check rule is different for each of the columns?

My current site uses version 8.7 DataStage with Teradata 14.0.

Are there any other error messages in the log? The messages you've cited are usually beginning a cleanup phase.

Or they could indicate that someone has issued a job stop request.

Is this error reproducible?

The pith of my response was already visible, so I've exposed the remainder.

Invoke a routine that applies an Oconv() function specifying the NLS map, and check the value of Status(). It will be 0 if the NLS mapping was successful, or a non-zero value otherwise. Use that result to determine whether to reject the row or not.

There are several ways this might be accomplished. In a real life example it would depend on the wider picture - the rule that determines which rows (which key values) go into which files. In most cases you'd be looking at constraint expressions in a Transformer stage, or you might be looking at usi...

Contrast "standardization", "verification" and "certification".