Limit the number of records
Posted: Thu Jan 04, 2007 10:42 pm
Hi,
As i wanted to limit the number of records to be loaded in a job, i used this option - job properties -> exectuion -> force complie
here, i faced a problem, all the limited records which are read by the datastage, are being wriiten to the log and so it takes more time and occupies more server space too...
can anyone pls let me know is there any way i can avoid this or suggest other solution to limit the records to be loaded in the job.
Thanks,
As i wanted to limit the number of records to be loaded in a job, i used this option - job properties -> exectuion -> force complie
here, i faced a problem, all the limited records which are read by the datastage, are being wriiten to the log and so it takes more time and occupies more server space too...
can anyone pls let me know is there any way i can avoid this or suggest other solution to limit the records to be loaded in the job.
Thanks,