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
- 13219 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
List out all forms of LOCKS that are available in Teradata.
How will you solve the problem that occurs during update?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is a level of granularity of a fact table?
How can bottlenecks be identified?
What do you mean by caching in teradata?
What is teradata? What are some primary characteristics of teradata?
What is the purpose of using case expression in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
what is object level locking ? where do appear this type of locking ?
How do you do backup and recovery in teradata?
What is the function of parser component in teradata?
Highlight the limitations of TPUMP Utility.
Can you fastexport a field, which is primary key by putting equality on that key?
