Why Multiload and Fastload does not supports SI,JI,RI and
TRIGGERS?
- 4 Answers
- 11275 Views
- I also Faced
- E-Mail Answers
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 |
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Can we collect statistics on table level?
What are some primary characteristics of teradata?
What are the things to be considered while creating secondary index?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
How to relege locks in fastload and multiload? example?
What do you mean by parsing?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the various indexes in teradata? How to use them?
what is the difference between start schma and Fsldm?
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
Teradata 
