Need help to know how to improve performance while using flat file in OGG
User is using below flat file extract and writing in .dsv file.Now he want to improve the performance as user experiencing lag on pump process while writes in file.
Below are the details of pump process :
--
-- PUMP - Netezza - Load via NZLOAD utility
--
EXTRACT com3ext
NODYNAMICRESOLUTION
SOURCEDEFS ./dirdef/nzcom.def
CUSEREXIT ./flatfilewriter.so CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES &
PARAMS "./dirprm/com3_ffwriter.properties"
TABLE RDS_BCOM.SYSDBA.CM_SELLER_PROMO_CLAIMS;
Kindly let me know what are the things need to checked from performance point of view and please suggest how to improve the performance.
Thanks in Advance.