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
- 15442 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
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
If RDBMS is halted what will you do ?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are the various indexes in teradata? Why are they preferred?
What are types of partition primary index (ppi) in teradata?
Explain the term 'tables' related to relational database management system?
Explain the advantages of partitioned primary index in a query?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is the maximum number of dml can be coded in a multiload script?
How many types of joins are there in teradata?
What exactly do you know about catching in teradata?
What do you mean by teradata intelliflex?
What are the different methods ot loading a dimension table? A fact table etc?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain teradata vs. Redshift?
