If the table is empty and the amount of data to be loaded is in millions,

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

Question Posted / tdguy

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How is the teradata different from oracle?

1050

What is the use of having index on table?

966

What are the design features involved in teradata?

996

What are the steps to create a data model?

1001

Explain teradata utilities?

1000

What are some primary characteristics of teradata?

959

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1099

What is the purpose of joins in teradata and what are the available join types?

1025

what is object level locking ? where do appear this type of locking ?

3454

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

975

Explain Teradata performance tuning and optimization?

1117

How to identify ppi columns?

1121

What is meant by a Clique?

1008

What are the components used in smp and massively parallel processing (mpp) machines?

1016

What is the opening step in basic teradata query script?

1000