Why FLOAD does not support multiset tables??

Answers were Sorted based on User's Feedback



Why FLOAD does not support multiset tables??..

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

Why FLOAD does not support multiset tables??..

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 does not support multiset tables??..

Answer / veeru

Coz fast load not allowed dupluicate rows

Is This Answer Correct ?    8 Yes 6 No

Post New Answer

More Teradata Interview Questions

Explain teradata architecture in detail with a diagram.

0 Answers  


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?

3 Answers   IBM,


what are the file sizes in your project?

2 Answers  


How can we load single row of data into teradata database. please give me the process.

3 Answers  


What is spool space? Why do you get spool space errors?

0 Answers  






What is the meaning of Caching in Teradata?

0 Answers  


How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  


can i call router is a passive transformation

2 Answers  


What is a node in teradata? Explain

0 Answers  


Describe the between keyword in teradata?

0 Answers  


What is the difference between fastload and multiload?

0 Answers  


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  


Categories