DSXchange

Hi, I am using DRS stage in the target and source is Sybase. The process used in the DRS is insert or update. Update action (in DRS stage) : Insert new rows or update existing Design: source -> trn -> target (it is just column to column mapping) The key columns are selected in target and source but ...

It works for me now.

Andy, thanks a lot.

Hi,

I have 10 jobs to be run in parallel and need to pass a value to a parameter from the sequence job which is in all jobs ie. in runtime.

eg. PR_DATE needs to have current_date -1 in all the jobs.
Is there a way how this can be acheived?

Thanks for your time.

Thanks

Thanks for the suggestion

Now split up the jobs into batches and executing them from sequence

Hi, I am trying to load 16 Oracle tables from Sybase in parallel. Randomly some table or other fails in the process due to connectivity issue. We my sequence job starts all the jobs run in parallel, is this correct way of performing the data load. We are having in this way to have better completion ...

Is the length fixed ie. (A...H) or dynamic?

Hi, I am trying to read a sequential file with multiple columns. The total number of columns depend on the value in first column. Then take the values from the columns and load it into Oracle tables. Say, (as given below) if first column value is A1 there will be 5 columns or if it is A2 there alway...

Thanks.
I have now split the load into 2 jobs.. Now the time taken for load is better.

Thank you.

Basically we are loading from Sybase to Oracle tables, it takes close to 30 mins. for loading 2 million records. It is direct mapping and no validation. For the first run it will be full referesh but then onwards it would be delta records. Hence we are using a upsert process (Update then insert) SYB...

There was invalid data in the column and now looks fine

Yes, you are right. The next column was a float column and that had actually caused the issue.

I see the datatype as char(9) only in Sybase

Hi, The job what I am trying to do is get all the records from Sybase table and load Oracle table (Upsert mode). During the job execution the following warning message is thrown. Unable to set output decimal field value from argument string '9.9999999999999995e-08' in function setOutputFieldAsDecima...

isolation level has been set to serializable
hint used is TABLOCKX