DSXchange

A one-node configuration should not be able to create self-deadlocks. Look farther - is anything else accessing/updating the same Teradata table(s)?

Could you (perhaps) generate the element row number in an upstream Transformer stage using stage variables? Then, you would be able to use this value in the XPATH expression you generate on the reject link.

Craig is correct, noting that you get precisely one row of output if you have no grouping column(s).

In a parallel Aggregator stage you must provide at least one grouping key.

The ideal volume is "all you've got". The most accurate answers are to be had by profiling all the rows in a table. Don't try to do too many tables at once - they can be scheduled to run consecutively if desired. What do they mean by "performance"? Could they do it any faster by ...

I wonder if it's the "#" character ("not equal to")?

I've just finished installing version 8.1.2 FP3 on Windows Server 2003 (the supported Windows O/S), and it exhibits the same error. Did you get any response from support?

There's a problem in your logic somewhere.

Computers only do precisely what they're told to do.

Yes, because of the common domain.

The only possible issue is that you're not setting the flag to 'N' in the expired row during your update process.

U is one of our infrequent posters and therefore it may be some time before U can give you "ans", whatever that is. We strive for a professional standard of written English on DSXchange, which helps those for whom English is not a first language. Professional written English includes payi...

Please advise the answer to help future searchers. You have marked this thread as Resolved, and yourself (in your signature block) as an ETL expert. Your profile ("ready to help others" in DataStage) confirms this self-assessment. It would help future searchers even more if you could choo...

Not to mention the Connector for MQ Series

Do you mean the Information Server launch (yes, definitely going) or the Cognos launch (possible, maybe)?

reachmexyz wrote:

anbu wrote:

Code: Select all

Trim(field,'0','L')

This will not work on a decimal directly.

Have you tried it? Decimal to string is an implicit conversion, so it should work.