Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2010 @ 15:09:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>