DSXchange

Does anyone faced this or have any idea about

Operator terminated abnormally: received signal SIGSEGV

Is this sateeshbabu mandepudi? Well i changed to sequential mode. just to sack for work and it works. But the real question remains is why parallel updatation doesn't work?. is this something underlying database doesn't support it? I have four nods and everything DBA comes and says datastage tried t...

I finally have to choice server job to update a table.

- checked with increasing INITRANS on table
- And not doing any other tasks other the updating.

Hi All,

Did any one faced this issue when updating data in oracle 9 table using oracle enterprise stage?

sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource

Yeah, Most of them just waiting for pulling someothers leg

When the things not working, have to work even on nights

why i am worried is when ever i post mostly get reply only from you. No other will reply.. this me

Thanks for that. Soon i will be bororw a premier membership. by then let me try to crack ur code. 8) Well by now... using join stage with left outer join with left link=source and right link=target(reference) and output contains is both new and existing records. How to distinguish between between th...

Thanks ray,

Just want to do,
- Insert if primary key is not present. else if present
then set some columns to null.

Can it is possible without change capture/difference stage?.

I checked there are no duplicate key coming from source

Two questions: 1. Does the input data contain duplicate key values? A- looking based on primary keys 2. What alternative do you plan for detecting change when the row already exists in the target table? .. A-If the row exists with same key then i just want to update few columns in target table, that...

I mean, Don't want to abort the job

Don't even want to insert those records instead i am happy to collect in peek stage. but can affort to abort the job.
I hope you have the answer for this.

Hi, Job fails While loading into oracle table if referential integrity for some records could not meet, thats fine. i can take those records into peek stage. But i don't want to abort the job. :oops: I am using reject records=true at oracle enterprise stage and passing into sharecontainer where it l...

Hi, I want perform insert if new record or update if exits (don't look for change columns) :wink: Insert: if primary key does't exist in target ( can do with Change capture code=1) Update some columns if key exists in target (if i use change capture it looks of change column which i don't want to pe...

How to improve time in job compilation?
takes 30min to compile and 1.5 min to run the same job.

Its medium job complexity
please let me any bottlenecks to get ride off.

Well.
This works DfloatToDecimal(AsDouble(Input))
even for exponential values.

But still does some minor rounding

Thanks