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
- 14963 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 is the meaning of Caching in Teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Differentiate database data and data warehouse data?
How does hashing happens in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the updated features of teradata?
Where is teradata rdbms used?
Can we collect statistics on table level?
What is the command in bteq to check for session settings ?
What are the 5 phases in a multiload utility?
What is the multi-insert?
Explain amp in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
How to run a query in teradata?
What happens when a node suffers a downfall?
