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 |
Explain the term 'row' related to relational database management system?
What do you mean by ttu in teradata?
Describe the between keyword in teradata?
How can bottlenecks be identified?
wt r before journal& after journel.....in teradata
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
What are default access rights in teradata?
Explain the new features of teradata?
What are the available primary index types in teradata.
if collect stats but it show low confidence why?