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
- 15237 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 joins in 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?
What are some primary characteristics of teradata?
Describe the between keyword in teradata?
Where is teradata rdbms used?
What are the different functions included in the server software?
What is primary index and secondary index?
Why managing the data is important?
What is logical data model?
Can we collect statistics on multiple columns?
How to run a query in teradata?
What are the scenarios in which full table scans occurs?
What are the available join types in teradata?
What are different table types used in teradata?
Explain the term 'columns' related to relational database management system?
