Job running slow

Hi,
Job1 is running for 10 minutes for the first time and the same job1 is running for 15 minutes for the second time ,the load being the same for both.Could someone explain..

Questions by sunitha.gummudu

Showing Answers 1 - 6 of 6 Answers

Raju Nath

  • Jun 27th, 2013
 

Hi
you can use the delete and then load command during loading then it will be the same time.

First time when you are loading that time the dataset/table is empty that is why its taking less time but for the second time its cheeking those data are in the dataset/table due to the table/dataset constraints.

  Was this answer useful?  Yes

One reason could be that - for the first time the job is just loading/inserting data into target.

When you run the same job again, it would take more time as it tries to update from second time. Update loads are very expensive because, for each record from source, system has to identify a record with same key in the target and then update the record with info from the source.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions