One Star

tOracleSCD - how to improve performance ?

Any idea, how to improve the performance of the compoent tOracleSCD?
thanks!
4 REPLIES
One Star

Re: tOracleSCD - how to improve performance ?

There are at least 2 points I can suggest at the moment.
1) Use existing connection in job.
2) Use tOracleSCDELT if your database is not so busy, as it Extracts Loads data into database then does the processing on the database server using sql queries.
--
Regards,
Vinod
One Star

Re: tOracleSCD - how to improve performance ?

A few more I can think of:
- create an inner join with the existing data to distinguish if records are real updates or new records. Then insert new records in a separe flow as version 1
- use indexes on destination table
One Star

Re: tOracleSCD - how to improve performance ?

saukema
I am not sure how you would seperate new vs update and do the processing. Appreciate if you could provide more details.
One Star

Re: tOracleSCD - how to improve performance ?

Vinod
I have tried using tOracleSCDELT. It is working fine if both source and target are in the same schema. if the source table is in different schema, it is not working even though permission is available.
Also this compoent does not have option to include Type 0 fields.
Any idea how to overcome these issues?