Need Help in desigining
Posted: Thu Sep 15, 2011 5:19 pm
Hi All,
I have a requirement to inserts records into oracle table based on 2 scenarios.Table has 30 fields and 15 fields were defined as Unique keys created unique indexs.
Scenario 1 : --- Process records with specific indicator (15th field) say <> 'V'
Need to upsert records (have to update 14th and 15th fields too).
Scenario 2:--- Process records with specific indicator (15th field) = 'V'
Need to upsert records with all 15 fields.
Created dsjob and using constraint in the transformer where 15th field<>'V' (1st link) to Oracle EE stage/Connector stage. Here i have excluded 14th and 15th fields from keys in the stage and doing upserts by including where 15th field<>'V' in the update query.
and 2nd link from transformer where 15th field='V' as constraint, passing records to Oracle EE stage/Connector stage. Here i have selected all the 15 fields as keys and doing upserts by including where 15th field='V' in the update query.
Initial load is completed.Some of the tables have 20 million plus rows.
Results for delta load -- With Oracle Connector stage all records were rejected for both scenario's saying "Row cannot be updated".
I am still trying with Oracle EE stage.
Would i get desired output with this design?
Could you please throw your inputs.
Thanks in Advance
I have a requirement to inserts records into oracle table based on 2 scenarios.Table has 30 fields and 15 fields were defined as Unique keys created unique indexs.
Scenario 1 : --- Process records with specific indicator (15th field) say <> 'V'
Need to upsert records (have to update 14th and 15th fields too).
Scenario 2:--- Process records with specific indicator (15th field) = 'V'
Need to upsert records with all 15 fields.
Created dsjob and using constraint in the transformer where 15th field<>'V' (1st link) to Oracle EE stage/Connector stage. Here i have excluded 14th and 15th fields from keys in the stage and doing upserts by including where 15th field<>'V' in the update query.
and 2nd link from transformer where 15th field='V' as constraint, passing records to Oracle EE stage/Connector stage. Here i have selected all the 15 fields as keys and doing upserts by including where 15th field='V' in the update query.
Initial load is completed.Some of the tables have 20 million plus rows.
Results for delta load -- With Oracle Connector stage all records were rejected for both scenario's saying "Row cannot be updated".
I am still trying with Oracle EE stage.
Would i get desired output with this design?
Could you please throw your inputs.
Thanks in Advance