DSXchange

Or write into a single hash file or read from it or use link collector........

In short you have variety of solutions.

Do you run in multiple instance?

Do you run in multiple instance?

If the question is only with reference to target db update, you can leave it as it is and let the db update multiple rows for the same key.

You need to either include an additional col / attribute as key. Alternatively try to merge keys in a single row - which is not recommended.

Did you confirm that the data meets the requirement?

Also whether the method works with test data you know is valid.

The error appears to raise abort on Transformer_1, which I assume is the first (and only) transformer in the job.


Can you check whether there is any logic embedded as part of the transformer.

Is that the only warning or critical message in the log? Did you reset the job to see any info in the log?

Double cheers for posting the result. It will be useful for other people searching the forum for similar issue.

You appear to have a different Ora Home set for datastage.

Check which one is correct.

Also your LD_LIBRARY_PATH is pointing to Ora 9i.

You can gather the csv file and prepare the xml using xml writer.

Search for DSGetJobInfo.

Try using join stage.

Do you have any 'wait for file' stage in it?

Before proceeding, you need to answer one question. Is the lookup to be performed on some condition in source data or reference result?

Depending on this, you can decide whether to use a single reference or double.