Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 17:37:59 GMT

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

Try following if it helps,

1) Create your target table as multiset.

2) Make sure target table is empty before loading.

3) Look at the explain of your query and find out what "merge step" is doing when loading data into target table. There might be some skew.

Regards,

Ravi Singh

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