If the table does not have duplicates then which utility you
can suggest to load the data ?
Answers were Sorted based on User's Feedback
Answer / tdguy
If the table is empty and the amount of data to be loaded
is in millions, then, fload would be a better option.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mallikahrjunarao rayidi
Fastload is better for unique rows loading
Is This Answer Correct ? | 2 Yes | 0 No |
How do you see a ddl for an existing table?
How to relege locks in fastload and multiload? example?
I want to write one query How to get Matched records and unmatched records in table?
Explain teradata vs. Redshift?
What is node? How many nodes and amps used in your previous project?
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
Explain teradata utilities. What is multiload, fast load, tpump?
What is Join Index in TD and How it works?
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 is real time and near real time data warehousing?
What is the opening step in basic teradata query script?
Name the five phases that come under MultiLoad Utility.