Answer Posted / 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 |
Post New Answer View All Answers
In BTEQ, how are the session-mode parameters being set?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Define views in teradata with syntax.
What is the purpose of joins in teradata and what are the available join types?
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 newly developed features of Teradata?
What is oltp?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Discuss the advantages of using partitioned primary index in a query?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain the term 'primary key' related to relational database management system?
What are the commands to make a new table, change a table and remove a table in teradata?
What is dimensional modeling?
What is the difference between fastload and multiload?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?