Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
Answer Posted / hari m
quoted points absolutely correct. i.e,
FAST LOAD does not support duplicate records...and it does
not support SI,JI,RI,HI because these require communication
between AMP's
I feel the posted ans is still not appropriate!
NUSI concept is same for even fload, as stated above in
NUSI subtable exists in the same amp so mload supports.
then why fload does not supports??
Now I guess my question more clear!!
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are default access rights in teradata? What explicit right can be given to a user?
What is the maximum number of dml can be coded in a multiload script?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the different table types supported by teradata?
What are the uses of bynets in multi-node systems?
What are the joins in teradata and how many types of joins are there in teradata?
Highlight the need for Performance Tuning.
Highlight the points of differences between the database and user in Teradata.
If RDBMS is halted what will you do ?
What are the different methods ot loading a dimension table? A fact table etc?
List out all forms of LOCKS that are available in Teradata.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
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 ?