I am using PC 6.2.
My mappings loads data from a flat files to Oracle database. File size range from 1 record to 1,000,000 records, most of the times file size will not exceed 10,000 records. I am caching two tables, one cahing 4,000,000 and other 1,000,000 records. For any given file though the file size is one recors my process runs for 5 to 6 mins, and for source with 1,000,000 records takes about 30 mins. I am concern about the performance, how can I reduce the processing time.
Can some one advise me on the cacing strategy.
My mappings loads data from a flat files to Oracle database. File size range from 1 record to 1,000,000 records, most of the times file size will not exceed 10,000 records. I am caching two tables, one cahing 4,000,000 and other 1,000,000 records. For any given file though the file size is one recors my process runs for 5 to 6 mins, and for source with 1,000,000 records takes about 30 mins. I am concern about the performance, how can I reduce the processing time.
Can some one advise me on the cacing strategy.