Lables

Wednesday, 11 September 2013

Why FLOAD does not support multiset tables?

Fastload utility does not support duplicate rows.
1.Since MS table supports duplicate rows Fast load cannot load MS table.
2.Restart logic is one of the reason. Fast load is one of the utility which loads data in blocks (64K). During restart Fast load sends some of the rows for the second time which occur after a checkpoint. Due to this Fast load rejects duplicates.


For example consider 20 rows to be loaded in a table. FL utility is used to load the table and checkpoint is 5 rows. If restart occurs after 7th row FL may send 6 and 7th to AMPs during the restart. These records would be considered as duplicates and rejected

No comments:

Post a Comment