Archives of the TeradataForum
Message Posted: Mon, 03 Aug 2015 @ 10:24:42 GMT
On top of what Dave already said, loading target tables directly with TD loaders can bind your hands later when you try to optimize some queries.
There are restrictions when it comes to loading tables with indexes (especially join indexes an USIs) and recreating them every time may be very consuming. It can actually jeopardize your optimization attempt.
Loading into noPI tables is also faster, because the engine doesn't have to bother with data redistribution and sorting. And faster loading into staging tables means faster release of load tasks, which is a limited resource as well.
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|