Page 1 of 1
Retrieving info from sequential file
Posted: Tue Mar 15, 2005 3:41 am
by krystlecsy
An ETL job was developed to read from sequential file, which has 50,000 records. This job runs for about 1 1/2 hour and I would want to know is there a way to make the retrieval of data from the sequential file to be quicker?
Posted: Tue Mar 15, 2005 4:18 am
by roy
Hi,
dont hold back info that might help you get a better reply!
more info:
1. what are you doing beside reading the file? (number of lookups, are there and how many complex derivations, Stage variables?...)
2. are you using local disks or storage?
3. how many nodes are configured?
4. is the job run in parallel ? (yea it an run sequencially)
5. how many columns are there in he file?
6. are you using NLS enabled version?
7. more specific platform info might help (OS, number of CPUs and such)
thees are the things that come to mind at the moment....
IHTH,