Hello all,
There is a table with 4 columns in that 3 columns has been
already loaded with 5 million records.4th column is
empty,Now I have got 5 million records data which has to be
loaded into 4th column.How can I load this data fastly in to
the 4th column with out using update
- 5 Answers
- 13202 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answer Posted / mohan
I would prefer to go with Multiload utility. Since we are
not sure all the records from flat file are equivalent to
the data which are already stored in teradata database. so
if we use multiload upsert concept we can load newly
available data as well as can update the 4th column. And we
can easily pick up the details how many new and how many are
updated, etc., etc., Please let me know if it makes sense!!!
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the commands to make a new table, change a table and remove a table in teradata?
What is database exceptions in teradata?
What do you mean by fastexport in teradata?
During the Display time, how is the sequence generated by Teradata?
Explain Teradata performance tuning and optimization?
Explain fallback in teradata?
List out all forms of LOCKS that are available in Teradata.
What are types of partition primary index (ppi) in teradata?
What are the various indexes in teradata?
What are the design features involved in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the various indexes in teradata? How to use them?
Can we collect statistics on multiple columns?
What interface is used to connect to windows based applications?
Explain teradata architecture in detail with a diagram.
