If the table does not have duplicates then which utility you can suggest to lo

If the table does not have duplicates then which utility you
can suggest to load the data ?

Question Posted / narsingrao

Answers were Sorted based on User's Feedback

If the table does not have duplicates then which utility you can suggest to load the data ?..

Hi,

>>If the table doesn't have any
duplicates(triggers,sp,ji,hi,nusi,usi) we go for fastload.

>>if the table data <1mill we go for bteq

Is This Answer Correct ?

5 Yes

1 No

If the table does not have duplicates then which utility you can suggest to load the data ?..

Answer / tdguy

If the table is empty and the amount of data to be loaded
is in millions, then, fload would be a better option.

Is This Answer Correct ?

4 Yes

0 No

If the table does not have duplicates then which utility you can suggest to load the data ?..

Answer / mallikahrjunarao rayidi

Fastload is better for unique rows loading

Is This Answer Correct ?

2 Yes

0 No