what is use of fload loading into set table?
Answers were Sorted based on User's Feedback
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 |
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
How does indexing improve query performance?
Can we load a Multi set table using MLOAD?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the 5 phases in a multiload utility?
Can you fastexport a field, which is primary key by putting equality on that key?
What do high confidence, low confidence and no confidence mean in explain plan?
What is meant by a Virtual Disk?
What are default access rights in teradata?
Can you load multiple data files for same target table using fastload?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
If table have access lock.In the same table write lock is posible or not?