Why Fload doesn’t support multiset table?




Answers were Sorted based on User's Feedback



Why Fload doesn’t support multiset table?..

Answer / rajneesh

FastLoad support Multiset table but does not support the
duplicate rows.
Multiset tables are tables that allow duplicate rows.
When FastLoad finds the duplicate rows it discards it. Fast
Load can load data into multiset table but will not load
the duplicate rows.

Is This Answer Correct ?    30 Yes 3 No

Why Fload doesn’t support multiset table?..

Answer / bharath

after you restart the fast load job,

Therefore, some number of rows will be sent to the AMPs
again because the restart starts on the next record after
the value stored in the checkpoint. Hence, when a restart
occurs, the first row after the checkpoint and some of the
consecutive rows are sent a second time. These will be
caught as duplicate rows after the sort. This restart logic
is the reason that FastLoad will not load duplicate rows
into a MULTISET table. It assumes they are duplicates
because of this logic.

Is This Answer Correct ?    13 Yes 3 No

Why Fload doesn’t support multiset table?..

Answer / tdguy

-->Fload does not support multiset tables because it does
not support duplicate rows.
-->Fload does not allow duplicate roww, because of the
restart logic.Whenever a failure occurs and restart occurs,
fload identifies the checkpoint and sends some records to
the amps which were already sent. This is because, failure
occurs at checkpoint rarely. Assume checkpoint is to be
taken every 10 rows and the failure occurs exactly while
processing at the 14th row. When Fload is restarted, it
identifies the checkpoint and sends the rows starting from
11th row. However the rows 11 to 14 will be captured as
duplicates and just counted. This can be seen in the stats
of Fload.
TOTAL DUPLICATE ROWS = 0
Though these rows are not captured, these rows are just
noted. This is the reason, Fload does not support duplicate
rows.

Is This Answer Correct ?    10 Yes 2 No




Why Fload doesn’t support multiset table?..

Answer / priyanka trivedi

restart logic is the reason that FastLoad will not load
duplicate rows into a MULTISET table

Is This Answer Correct ?    2 Yes 1 No

Why Fload doesn’t support multiset table?..

Answer / amit sethiya

I believe Fastload silently discards duplicate rows. They don't go to the error table.

Many of the differences between FastLoad and MultiLoad are due to the fact that MultiLoad loads by way of an intermediate work table, whereas Fastload loads directly into the target table, which is sorted later. The sorting process automatically removes duplicate rows. The records that MultiLoad loads the work table during the acquisition phase are not exact images of the target rows. They contain sequence numbers that are generated by the client module. If the acquisition phase is restarted, the client may resend rows that were previously sent after the last checkpoint, as is the case with Fastload. However, only duplicate records with matching sequence numbers are discarded when the work table is sorted at the end of the acquisition phase. Duplicate records with non-matching sequence numbers are retained.

Is This Answer Correct ?    1 Yes 0 No

Why Fload doesn’t support multiset table?..

Answer / hardeep

Thanks Priyanka for the answer but can u pls explain more about it. I didn't understand properly.

Is This Answer Correct ?    0 Yes 0 No

Why Fload doesn’t support multiset table?..

Answer / laks

fastload will rmove duplicates while loading ,But performence of the laod will degrade.

Is This Answer Correct ?    0 Yes 0 No

Why Fload doesn’t support multiset table?..

Answer / sharmistha meher

multiload uses checkpoint too, why this allows duplicates then?

Is This Answer Correct ?    0 Yes 0 No

Why Fload doesn’t support multiset table?..

Answer / srinu

Fast Load will load the Data Fastly,
Mean Concurrently,Bulk Insert.
Internally TeraData server will Create
Bulk insert DML statament
(Like: insert into Table1 as sel * from Table2
with data)
For Fast Performence it will not support the
duplicate values,Refential Intigrity,,,,


If u know the Better answer compare to this let me Know,
srinu.srinuvas@gmail.com

Is This Answer Correct ?    0 Yes 15 No

Post New Answer



More Teradata Interview Questions

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,


I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  


How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   IBM, Comsys,


Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  






Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  


How a Referential integrity is handled in Teradata?

5 Answers  


what is single value and Multivalue ?

1 Answers   IBM, Wipro,


Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,


What is a pseudo key? What is its use???

2 Answers   Mphasis,


What are two examples of an OLTP environment?

4 Answers  


Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,






Categories