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
- 15262 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 tools would you use for that?
What is the opening step in basic teradata query script?
Where is teradata rdbms used?
What is database exceptions in teradata?
What do you mean by caching in teradata?
What are default access rights in teradata?
Explain teradata utilities?
what are the day to day activities of teradata DBA ?
Explain fastload in teradata?
What are the different table types supported by teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How do you define Teradata?
What is meant by a Clique?
What are the components used in smp and massively parallel processing (mpp) machines?
