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

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

Question Posted / vinay

4 Answers
12848 Views
I also Faced
E-Mail Answers

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