Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15213 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 design features involved in teradata?
If RDBMS is halted what will you do ?
Explain amp in teradata?
What is database exceptions in teradata?
What happens in a conflict? How do you handle that?
What are the different table types that are supported by teradata?
List out all forms of LOCKS that are available in Teradata.
Is multi insert ansi standard?
What is meant by a Channel Driver?
What is smp and mpp platforms?
What is the command in bteq to check for session settings ?
How do you verify a complicated sql?
What is meant by a Highest Cost Plan?
What are differences between teradata and ansi session modes in teradata?
What is the multi-insert?
