Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 13998 Views
- TCS, Tesco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / adi
Fload will allow multiset table. But there is no advantage
of loading multiset table using fload, becuase fload does
not insert duplicate rows. If we try to load multiset table
using fload with duplicate rows, they fload inserts
distinct rows into the target table and the duplicate row
count displayed under second error table.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / yuvaevergreen
Fastload utility does not support duplicate rows.
1.Since MS table supports dup rows fastload cannot load MS
table.
2.Restart logic is one of the reason. Fastload is one of the
utility which loads data in blocks(64K). During restart
Fastload sends some of the rows for the second time which
occur after a checkpoint. Due to this Fastload rejects
duplicates.
For example consider 20 rows to be loaded in a table. FL
utility is used to load the table and ckpt is 5 rows. If
restart occurs after 7th row FL may send 6 and 7th to AMPs
during the restart. This records would be considered as
duplicates and rejected.
| Is This Answer Correct ? | 12 Yes | 2 No |
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What are the 5 phases in a multiload utility?
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.
what is use of PI(primary index) AND SI(secondary index)
What are the multiload utility limitations?
Can any one plz provide the teradata interview questions?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
how do you handle ET and UV errors ?
What interface is used to connect to windows based applications?
If table have access lock.In the same table write lock is posible or not?
Does SDLC changes when you use Teradata instead of Oracle?
Teradata 
