Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 12853 Views
- Teradata, I also Faced
- E-Mail Answers
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 some primary characteristics of teradata?
what are the day to day activities of teradata DBA ?
What is upsert statement in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the difference between global temporary tables and volatile temporary tables?
What is the purpose of upsert command?
What do you mean by parsing?
What is the use of virtual processor connectivity in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
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 ?
Which is more efficient group by or distinct to find duplicates?
Is multi insert ansi standard?
What are differences between teradata and ansi session modes in teradata?
What are different table types used in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
