Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 13916 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 |
Different phases of multiload?
why should we go Teradata over Oracle,what is the main differences?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Explain the term 'primary key' related to relational database management system?
What are the various reporting tools in the market?
What are the different functions included in the server software?
how many modules are there in telecome domain?how to explain the architecture?
Why are oltp database designs not generally a good idea for a data warehouse?
What is the command in bteq to check for session settings ?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Is multi insert ansi standard?
Teradata 
