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.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

 

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.