Hi, Though in case of NUSI the subtable rowid and base table rowid wil

Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.

Please explain in this regard.

Thanks in advance.

Question Posted / subbu

4 Answers
14162 Views
Teradata, I also Faced
E-Mail Answers

Answer Posted / subbu

Hi,

Though in case of NUSI the subtable rowid and base table
rowid will be on same AMP,FLOAD doesn't support the multi
AMP communication and even the NUSI contains dupliate
values aswell so either of these are not supported by FLOAD.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

In BTEQ, how are the session-mode parameters being set?

1143

What is logical data model?

1200

What are the uses of bynets in multi-node systems?

1028

What is upsert statement in teradata?

1130

What are different table types used in teradata?

1039

How do you do backup and recovery in teradata?

1014

Explain fastload in teradata?

1099

Explain the parallel data extension in teradata?

1093

What are the different functions included in the server software?

1028

Explain fallback in teradata?

1053

What can be achieved by using the teradata rdbms?

1032

What is bteq script in teradata?

1151

How do you define Teradata?

1031

Highlight the differences between Primary Key and Primary Index.

1087

What exactly do you know about catching in teradata?

1036