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.