Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14170 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 |
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
Aborted in Phase 1 data Acquistion Incomplete in fastload?
Describe primary index in teradata. And what are the available primary index types?
How many macros we can create inside a macro
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
what are the roles and responsibilities of teradata DBA ?
What is the command in bteq to check for session settings ?
How do you determine the number of sessions?
What is logical data model?
How would you load a very large file in teradata in general?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Teradata 
