what is use of fload loading into set table?

Answers were Sorted based on User's Feedback



what is use of fload loading into set table?..

Answer / yuvaevergreen

Though mload can be used to load SET table, Fload would be faster than mload. Both Fload and set table do not support duplicate rows which can be a advantage. Add, if you find more.

Is This Answer Correct ?    7 Yes 1 No

what is use of fload loading into set table?..

Answer / tdguy

No dupes allowed.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Teradata Interview Questions

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,


Explain the term 'primary key' related to relational database management system?

0 Answers  


What does Amp contain and what are all the operations that it performs?

0 Answers  


If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,


Define views in teradata with general syntax.

0 Answers  


Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,


What are the frequently used data types in teradata?

0 Answers  


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

4 Answers   Comsys, IBM,


In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  


Highlight all the modes that are present under Confidence Level.

0 Answers  


How do you Generate Sequence in Teradata?

3 Answers   TCS,


Explain about Skew Factor?

6 Answers   TCS,


Categories