Why Multiload and Fastload does not supports SI,JI,RI and
Answers were Sorted based on User's Feedback
Answer / vinay
Above all concepts require communication between Multiple
As per Fastload and Multiload doesnot provide any
communication b/w multiple Amps and they Operate
As concept is violating as well as it takes time to
implement the above operation they are not allowing them.
|Is This Answer Correct ?||12 Yes||1 No|
Answer / yuvaevergreen
Vinay is correct.
USI - generally stored in subtable in a different amp other
than the amp having data row. Both the utilities do not
NUSI - The subtable is stored in the same amp itself. Mload
supports it and Fastload not.
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
|Is This Answer Correct ?||11 Yes||0 No|
Answer / dorai nagireddy
Vinay Sir simple answer is correct.Yuva your elaborated
answer is also correct.Thanks Vinay sir(Datawarehousing
Technologies faculty) and Yuva.
|Is This Answer Correct ?||2 Yes||0 No|
Answer / tdguy
USI,JI,RI and triggers involve multi amp communication.
Hence, both fload and mload dont these. But mload supports
NUSI alone as it is amp local.
|Is This Answer Correct ?||0 Yes||0 No|
What is meant by MATCHTAG in multiload utility?
What is meant by a Clique?
What are the different table types that are supported by teradata?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
How do you verify a complicated sql?
what is amp plz explanation
What are the various indexes in teradata? How to use them? Why are they preferred?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Mention a few of the ETL tools that come under Teradata.
Explain parsing engine in teradata?
How does indexing improve query performance?
How you will check the version of teradata?