DSXchange

There is a complete solution in my previous post.

Premium membership is not expensive, at less than 30c per day. All revenue from premium memberships goes to keeping DSXchange running, by helping to meet its hosting and bandwidth expenses.

Please delete your other post on this topic. Target ---> HashedFile | V Source ---> Transformer ---> ... ---> Target | V HashedFile The Hashed File stages refer to the same hashed file, and neither read cache nor write cache is used. You can pre-load the hashed file in an earlier job if this is more...

Read about the Iconv/Oconv "MD" (masked decimal) conversions, which can handle trailing signs.

Did you type these expressions in, or use the expression builder?

Let's try to get this into a specification. If #StringLike# appears anywhere in the DS_JOBOBJECTS record then return "FOUND" otherwise return "NOT". Is that right? So you don't need an INDEX() function, but you do need a LIKE operator. SELECT DS_JOBS.NAME AS JOB_NAME, 'FOUND' FRO...

So you'd prefer not to have DSXchange survive?

You'd better find out - and tell us - what the database maintenance team did, since this was clearly the cause of the new problem.

In the Administrator client on the General page of project properties.

In the Job Run Options dialog, on the General page.

Using an option to the dsjob command that I can't remember just now.

Why bother searching using Index() if you know that you only want exact match? Just use "=".

Those with premium membership will find my answer to be a complete answer to the original question. Premium membership is one of the ways that the hosting and bandwidth costs needed to keep DSXchange functioning are met. Premium membership is not expensive, at less than 30c (Rs12) per day, and that'...

Probably that you have not enabled the collection of operational metadata.

What are the ulimit settings for the user performing the installation?

Most of them need to be set to "unlimited". There are other considerations on AIX that need to be considered, such as the LDR_CNTRL environment variable (treatment differs on 32-bit vs 64-bit environments).

Try it. It doesn't handle tied ranks. To handle rank properly in ETL - and I continue to maintain that it's not an ETL task but a display task - you can use stage variables that detect change (perhaps from a Sort stage key change column) and decide whether to preserve or increment the rank. At the s...

What is your target?

What is your derivation expression?
(For example, setnull() alone will only and always set NULL - you need conditional logic that specifies when NULL should be set.)

Have you attended the IBM class "DataStage Essentials"? That's the easiest way to obtain this knowledge. Of course, it's also in the manuals and in the Info Center for Information Server. The parallel execution engine is called "Orchestrate" and uses the metaphor of an orchestra....