Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 14363 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / kishore
FAST LOAD does not support duplicate records...and it does not support SI,JI,RI,HI because these require communication between AMP's....and MLOAD supports NUSI because in NUSI subtable exists in the same amp so it supports.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Write a program to show the parser component used in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
List out all forms of LOCKS that are available in Teradata.
What's the difference between timestamp (0) and timestamp (6)?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How many codd's rules are satisfied by teradata database?
What is bteq utility in teradata?
How will you solve the problem that occurs during update?
What type of indexing mechanism do we need to use for a typical data warehouse?
How does hashing happens in teradata?
Why managing the data is important?
What are the different methods ot loading a dimension table? A fact table etc?
What are the various indexes in teradata? How to use them? Why are they preferred?
Highlight the differences between Primary Key and Primary Index.
What are the scenarios in which full table scans occurs?
