Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Why Multiload and Fastload does not supports SI,JI,RI and
TRIGGERS?

Answers were Sorted based on User's Feedback



Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?..

Answer / vinay

Above all concepts require communication between Multiple
Amps.
As per Fastload and Multiload doesnot provide any
communication b/w multiple Amps and they Operate
Independently.
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

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?..

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

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?..

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

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?..

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

Post New Answer



More Teradata Interview Questions

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,


What is meant by a Clique?

0 Answers  


What are the different table types that are supported by teradata?

0 Answers  


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 ?

2 Answers  


How do you verify a complicated sql?

0 Answers  






what is amp plz explanation

5 Answers   IBM,


What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  


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)

2 Answers   TCS,


Mention a few of the ETL tools that come under Teradata.

0 Answers  


Explain parsing engine in teradata?

0 Answers  


How does indexing improve query performance?

4 Answers   Satyam,


How you will check the version of teradata?

0 Answers  






Categories