DSXchange

The actual bottleneck is with the load only(As it is from a remote DB).

I have loaded the data to separate temp tables(For every query). Do you suggest text files to Oracle table load in reducing the load time?

The KPI here to be taken care of is load time of records from remote DB(which needs to be reduced).... and throughput.

Hi Ray,
In ETL context there is one OCA stage , a transformer and an output OCA stage used in the job. Since the remote DB is having millions of records, it takes 1-2 hours for completion...

Hi , I need to tune a server job which loads data from a remote DB using DBlink. The data is retreived from 2 DBlinks,Unioned and loaded to oracle table. The query is something like this: Select * from tableA@DBlink1 where cond1 or cond2 or cond3 or cond4 Union Select * from TableB@DBlink1. The job ...