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 |
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
What are the scenarios in which full table scans occurs?
How can we check the version of Teradata that we are using currently?
How do you design aggregate tables using teradata?
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?
can i call router is a passive transformation
Diff b/w v2r5 and v2r6 ?
How to run a query in teradata?
What is dimensional modeling?
What are default access rights in teradata? What explicit right can be given to a user?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
What is the difference between global temporary tables and volatile temporary tables?