Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload and Fastload does not supports SI,JI,RI and
TRIGGERS?
- 4 Answers
- 12724 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 |
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
Which is more efficient group by or distinct to find duplicates?
What is multi insert?
Increasing no of amps will increase performance. Is this true?
Difference between Teradata V2R5 and Teradata V12 versions?
Explain the term 'row' related to relational database management system?
What are the scenarios in which full table scans occurs?
Fast Load Script is failed and error tables are available then how do you restart?
what are the roles and responsibilities of teradata DBA ?
Explain teradata vs. Redshift?
What is teradata? What are some primary characteristics of teradata?
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
Teradata 
