|
Archives of the TeradataForumMessage Posted: Wed, 29 Sep 2010 @ 15:09:26 GMT
Hi naveen, Do you run the same job 30 times ,spaced by 1 minute interval ( bacause of 30 contries?) How big is your target TB ? Because your are not updating on pi, each etl job will put a table lock. So the overs jobs are locked until previous job update finish. ( the update could be quite long specially if your target TB have indexes) You probably have to rebuild you job to feed a stagging table with everty contries , using pi to put row hash lock and then update the target table from this staging table. Regards. Patrick
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||