Saturday, January 15, 2011

Can we load a Multi set table using MLOAD?

Can we load a Multi set table using MLOAD?
Answers:

We can Load SET, MULTISET tables using Mload, But here when loading into MULTISET table using MLOAD duplicate rows will not be rejected, we have to take care of them before loading.But in case of Fload when we are loading into MULTISET duplicate rows are automatically rejected, FLOAD will not load duplicate rows weather table is SET or MULTISET

1 comment:

  1. WHAT IS THE USE OF SET TABLE TABLE WHILE LOADING DATA USING FASTLOAD?

    ReplyDelete