DSXchange

How do YOU think you might go about it? What (if anything) have you already tried?

Our philosophy is to prefer to help you to learn, rather than to provide canned answers. If we were to do the latter, that would be consultancy and attract a charge.

Please be clear here.

Are we talking about a blank (" ") or a zero-length string ("") as the lookup key value? Your terminology is loose.

You have neither provided, nor asked DataStage to generate, the SELECT statement.

Check with Support. I'm unaware of any documented limit.

There's nothing wrong with negative values for surrogate key.

All a surrogate key has to provide is uniqueness.

If you're really bothered by this, use unsigned integers when viewing them. The binary storage is exactly the same.

It's correct, as far as it goes. The "difference" is absolute. They are totally different things. Nodes are about degrees of parallelism, and the resources available when processing using the parallel engine. Any number of processes can - theoretically, at least - run on each node. In prac...

devesh_ssingh wrote:use index function to search 1st occurance of pattern then pass the same in jp.

Justice of the Peace?

Please don't use potentially ambiguous or unclear abbreviations.

Possibly, but we can't really say because we don't know how large your rows are. If the smaller cache size is working (all your hashed file data fit into memory) then allocating more memory will have no effect.

The argument supplied to this routine is the name of the sequence (a name internal to DataStage), not necessarily the name of a table. Looks like the second table already has the "next" key. You need to check for this, or initialize the sequence, or use independent sequences, or some combi...

Look in the History section of C:\IBM\InformationServer\Version.xml

Have you tried using istool to export/import these components?

Looks like you have not got the input link order correct. These four fields come from one of the frequency inputs.

This what? They are all informational messages.

The pathname you have given for the state file does not refer to an existing state file.

You do need to create/initialize a state file for each surrogate key. Have you done that?

Why aren't you using SCD stage that does all that work for you?