DSXchange

We are migrating from Oracle 8i to Oracle 9i database. And we are using lot of ORAOCI8 stage . Is ORAOCI8 stage will working fine when we we migrate to Oracle 9i or we have to change the stage to ORAOCI9?

Thanks in advance.

Ascential Release :- 6.0.0.0 We have application written in Java and which is calling Ascential Datastage project. Ascential project is doing the ETL part. Some time if the load set size is big Ascential takes 8-9 hours to load the data but does not return control back to java. If the load set is sm...

Well, I complied it and saved it but It was a same problem. Just now I came to know that project got corrupted and it was not picking the changes. So we got a new project and not it is working.

-Thanks

In "Jobs" I have a "Control job" category and in that I have a job(LoadSetScheduler) which has a main entry point logic to our Ascential project. So when I am making modification in "job control" for some reason the modified code is not picked when we run the project. I...

Let say I choose a "multiple Instance" option (Job is refreshing a hash). If Job1 and job2 are refreshing a hash simultaneously and then job3 want to use the "hash" which got refreshed by job1 and Job2. So in this situation which values will be visible ( Rows refreshed from job1 ...

I am trying to share jobs in various sequences. Even thought the sequences are not running parallel, I am getting this error message. I am running sequence through "Job Control". SequenceNodeAttributeMap..JobControl (@OciNewAttributeValueInsert): Controller problem: Error calling DSRunJob(...

Thanks Craig and Ray, Row buffering feature was "on" at the project level. I turned that off and now the job is working fine. :-) But I have lot of jobs in the project which has row buffering "on" at Job level. So I am not sure that I should take row buffering feature off from th...

I tried without row buffering and still I am facing same issue. I tried at Job level. Is there a row buffering feature at Project level?

I have a datastage job in which I have couple of trasformers in series. I have seen for some reason in O/P I am getting duplicate rows. In order to debug the problem I have put the O/P of each trasformer in Sequential file. In the O/P of first trasformer their is no duplicate but in the O/P of next ...

If multiple job are using same hash file at the same time. Does that can bring any problem?

Yeah I am specifing the right project name.

In one of the Job I am reading from database and then in the trasformer I have couple of Hash file join and eventually the data is going in database. We have script which call this job and other jobs. So when we run that script this job is rejecting some rows due to primary key voilation ( Loading t...

Thanks Ray. I am using hash file and the process is working fine.

Ray, I have only grouping on those 4 columns and they are the Primary key in table which I am trying to insert through SQL loader. Roy, I am using SQL loader to load the data in database but in the aggregator I load the column information from table defination. I have seen that the table defination ...

I am also encountering similar problem. My job is generating a sequential file which have duplicate values, so in order to avoid that I have put a aggregator stage and that aggregator stage is taking off duplicates and generating some additional duplicates by it's own.

Please advise.