Job Compiles for a very long time.
Posted: Mon Jun 28, 2010 2:51 pm
Hi
I have some problem importing and compiling jobs. We have a project (say Dev project - ProjA). We have 5 job and 3 sequences. the first job is a truncate table job and multiple instance is enabled 3 of the jobs are called by 3 sequences the remaining one is an individual job.
Now I imported these jobs into ProjB. All the jobs are very simple, source is a file and target is Oracle 10g table. We use one sequential file stage, transformer stage and oracle stage. When i made an export from the ProjA, the export was completed in less than 3 to 4 minutes. but when I'm importing them to ProjB its taking more than 3 to4 hours (importing with executable).
After that if I compile the jobs that's taking another 3 to four hours. This happens only because of one particular job. This job doesn't have any much transformation, (but very little, and we add 2 extra columns in the target table). Can somebody explain me why this happens. I'm planning to re design the job.
I have some problem importing and compiling jobs. We have a project (say Dev project - ProjA). We have 5 job and 3 sequences. the first job is a truncate table job and multiple instance is enabled 3 of the jobs are called by 3 sequences the remaining one is an individual job.
Now I imported these jobs into ProjB. All the jobs are very simple, source is a file and target is Oracle 10g table. We use one sequential file stage, transformer stage and oracle stage. When i made an export from the ProjA, the export was completed in less than 3 to 4 minutes. but when I'm importing them to ProjB its taking more than 3 to4 hours (importing with executable).
After that if I compile the jobs that's taking another 3 to four hours. This happens only because of one particular job. This job doesn't have any much transformation, (but very little, and we add 2 extra columns in the target table). Can somebody explain me why this happens. I'm planning to re design the job.