DSXchange

It has to exist. Look in a "proper" hashed file directory. Note that it has a leading "." and a capital "T". UNIX is case sensitive. The leading "." means that it is a hidden file so you would nee ... You are right. I can view the hashed file after copying ov...

You don't have to copy .Type30 - it's empty. But it does need to be there. It signals to DataStage that this directory is a hashed file. Without it DataStage treats it as an ordinary directory, and ... Where is this .type30 file located? I don't find it in the hashed file directory. I am using a dy...

Yes, provided that the hardware is compatible (primarily byte order). For example, copying from a non-Intel chip to an Intel chip would cause difficulties, because every pair of bytes in the hashed ... Ok, but after I copied the hashed file cannot be read. It gives me junk characters. This is how I...

Can I copy the hashed file directory and its dictionary file in binary mode from one location to another loaction?

Yup, am using round robin. The output link turns green as soon as one of the input links turn green when the other input links are still in progress.

I think I have figured it out why. The 2 links into the LC complete at different time. One link is faster than the other. When one of the links has completed and the other is still in progress, the output link of LC will complete irregardless of the other link(s) that are still in progress. Therefor...

the transformer picks certain fields to be propagated and some simple transformation.
tried to recompile, reset and waited for at least 15 minutes.
I am really running out of clue as to this weird behavior.

Hi, I have the following job. Oracle1 ---> Xfm1 ---> link collector ---> sequential file ^ | Oracle2 ---> Xfm2 -------------| The output from link collector is always from the previous run's output of Xfm1, which is not expected. Example:- 1) Run 1 Output from Xfm1: 200 rows Output from LC: 100 rows...

I turned on the trace only for debugging purposes. Else, there is no reason why I should do so as it will take up more resources. Anyway, even without the trace turned on, it is still as slow if not slower. The job doesn't do any sorting. Anyway, there is no sort option in the merge stage. The trans...

job 1:-
file A ~2.4million
file B ~1.6million

job 2:-
output from job1 ~2.4 million
file C ~2.1million

from the number of records, they are almost the same. Job 1 flies but job 2 crawls...

both files are about the same size ~2.4million. Would pure inner join be much much faster? thks.

both files are about the same size ~2.4million. Would pure inner join be much much faster? thks.

I have 2 jobs with exactly the same design: merge ---> xfm ---> sequential file One job does about 20k rows/sec but another is only doing 100 rows/sec I check the log with trace level 1 could not get anything out of it. Would appreciate if anyone can advise. To add to the above:- job 1 merges file ...

I have 2 jobs with exactly the same design:
merge ---> xfm ---> sequential file

One job does about 20k rows/sec but another is only doing 100 rows/sec
I check the log with trace level 1 could not get anything out of it.
Would appreciate if anyone can advise.

chulett wrote:All Aborted/Restartable ones, yes. ...

ok, thanks
seems like I have to do it in a wrapper to do the reset of all the sequences for a fresh start of the job.