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
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
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?