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
How do you do backup and recovery in teradata?
Explain vproc in teradata?
What is the purpose of upsert command?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Can we collect statistics on multiple columns?
What are the different methods ot loading a dimension table? A fact table etc?
What is spool space?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Steps to create a data model?
Describe primary index in teradata. And what are the available primary index types?
Can we collect statistics on table level?
What are the functions performed by bynet?
What is the difference between teradata and oracle?
What is called partitioned primary index (ppi)?
What is the syntax for case when statement?