DSXchange

Hi When i run the job sequencer.. if the job has more than 50 warnings ..then the job aborts....while i run the job separately it works fine with more than 50 warnings...and i have set no limits for rows and same for the warnings... I found in the log after the abort sequencer job ...it says mode 0/...

Hi I have 9 job activity in a job sequencer and i have 4 routine activity for 4 jobs. I 'm using this routine and if this routine executed then i have to trigger the job corresponding to the routine. The routine have a return value. In routine activity options i choosed OK-Executed Successfully Opti...

Hi
It worked....
Thank you All

Hi My source is siebel business component and i'm transfering the records into the oracle table. one of the source has around 200,000 records. It takes more than 3 hrs to run this job. I've given my transaction size as 5000 and the array size as 1000 in the OCI plug in. Suggest me how to increase th...

Hi
I'm using @OUTROWNUM variable to generate surrogate keys...and I entered my records in the Oracle table. When i try to insert a new record i've to find the max surrogate key generated and include this in the derivation with an increment.
How can I do this!
Thank You

Hi I'm creating tables in Oracle....and the metadata is imported to datastage.. In Oraoci stage i'm using fully generated query.... The query shows the table as 'owner.tablename' now i want use the paratmeter as the owner name... Eg: Table defintion-----abcdef ( properties shows the table name and D...

Hi I'm using @INROWNUM and @OUTROWNUM ...for generating surrogate keys.... When i see the data for the first time the sequence starts from 1 and increments by 1..... when i run the job again by clearing the existing records...the sequence strats from where it ends..... Now i need this sequence to st...

Hi
I got a better idea now...let me implement this.....
Thank You very much
c41

Hi this is about Type 2 SCD... i want to check the incoming records...whether it is already exist or not...if the record is a new one then insert into the database table...if the record already exit the update record should be inserted with new values and simultaneously it should update the previous...