All Forums Database
Raja_KT 1246 posts Joined 07/09
13 Sep 2013
Loading nonpartitioned NoPI from a file

I am planning to load a  nonpartitioned NoPI from an external  file using mload, fload and tpump. What are the hiccups I may face?
Or is it better to stage first to a staging table and then load to NoPI? Then I dont see the advantage(S) of using NoPI, since I may use a staging table as well as NoPI table. I mean to say two tables.
Please suggest.
Thanks and regards,

Raja K Thaw

My wiki:

Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.