Loading nonpartitioned NoPI from a file

Database
Enthusiast

Loading nonpartitioned NoPI from a file

Hi,

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