DSXchange

Yup..Planning to get it...
The problem is occupied in too many things and not getting enough time for the things to do ...even browsing through this site too..

Ray, I couldn't read your full message as i am not a premium member. When that condition arises, the record is getting dropped. When i tried to collect it in a reject link i am getting all those dropped records. Can anyone tell me why and under which condition it is getting rejected instead of going...

Ray, I already have a reject link in the sequential file stage. There it is rejecting all the metadata non matching records. After that in the transformer i am checking for null values for mandatory columns. When i check for individual columns it is directed to either output or error file correctly....

Ram,

What you are saying is correct. So i tried the option trim(col_name) = ''
instead of using the function isnull() or isnotnull(). This is also giving problem.

Thanks
Shabnam

Hi I am facing a strange problem. My input is a fixed length sequentail file. I am doing a null check for all my mandatory fields. When i make two consecutive columns one nullable and other not null, the records is not passing to any of the output links. Not to the valid data nor to the error data. ...

Are you using the same user credentials in both the cases?

Thanks
Shabnam

We are adding the jobs as job streams and the maximum jobs in a job stream is 20. It is a daily job schedule we are monitoring. The jobs stay in the ready stage even after the scheduled time. It remains as such for a long time. It is not giving any errors. The situation is very critical, so we cance...

Hi all, We have some problems with our scheduler. It is IBM Tivoli 1.3. The problem is it is not triggering the job when it is sheduled. We have given standard priority of 10 for all jobs. It is based on time we have scheduled, but there is a delay in some jobs. Can anybody tell me if multiple jobs ...

DB stage used is Oracle 8, not Oracle OCI?
Will that also give problem?

Actually the project when developed it was using Oracle 8,
Then the database upgraded to 9i and the DB stage still remaining as oracle 8.

...Shabnam

Hi I am having problem in inserts to ODS and DW. In ODS i have some indexes also. The data is growing everyday both in ODS and DW. The total performance of the system is going down. Some of the jobs we identified which is taking more time. From that identified some statements. Would like to know in ...

Hi

I have some Insert and update statements in Oracle DB, which is taking too much of time which id not affordable. The table is having lacs of records. Do you have any option to optimise it.

Thanks and Regards
Shabnam

Hi all, In other utilities (Toad) also it is taking that much time. In other environment, the data is very less, so simulation is a long process( Need to do a data refresh from production server). I am not sure about the number of CPU's in the server as i am new to this project, but raised a ticket ...

Hey,

The database is Oracle 9i

Shabnam

I am using server stage. It doesn't have modify stage. Need to handle in transformer only.
Thanks and Regards
Shabnam

Hi

I am tuning a select query used in datastage job.It is having 35 NVL functions. If i handle this in transformer, will it increase the performance of the job as a whole.This single query is taking 1 hr in the production environment.

Thanks and Regards
Shabnam