Why Multiload and Fastload does not supports SI,JI,RI and
TRIGGERS?
Answer Posted / yuvaevergreen
Vinay is correct.
SI -
USI - generally stored in subtable in a different amp other
than the amp having data row. Both the utilities do not
support.
NUSI - The subtable is stored in the same amp itself. Mload
supports it and Fastload not.
JI -
TD generally stores the rows of join index across the amps.
Both the utilities do not support.
RI and triggers -
These are multi amp operations and any operation involving
communication between two amps is not supported by these
two utilities.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the difference between teradata and oracle?
Define views in teradata with general syntax.
How is MLOAD Teradata Server restarted after execution?
What do you mean by teradata intelliflex?
List out some of the primary characteristics of teradata.
What are types of partition primary index (ppi) in teradata?
In general, how do you optimze any sql in teradata?
How will you solve the problem that occurs during update?
What is teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the available join types in teradata?
What are the functions performed by bynet?
What is the difference between teradata and basic rdbms?
how can we analyze the locks ?