Why Multiload and Fastload does not supports SI,JI,RI and
TRIGGERS?
Answers were Sorted based on User's Feedback
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 |
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 |
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 teradata and why it is used?
What type of indexing mechanism do we need to use for a typical data warehouse?
List out teradata data types?
How can you track login parameters of users in teradata?
Highlight the limitations of TPUMP Utility.
What is the maximum number of dml can be coded in a multiload script?
How do you load Multiple files to a table by using fastload scripts?
What do you mean by teradata intellicloud?
What is bteq script in teradata?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
What are the joins in teradata?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?