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
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 different methods ot loading a dimension table? A fact table etc?
Explain the advantages of partitioned primary index in a query?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain and compare pros and cons of snow flake schemas?
What are the available primary index types in teradata.
Explain the new features of teradata?
Explain amp in teradata?
What is the difference between fastload and multiload?
What is node? How many nodes and amps used in your previous project?
Why do you get spool space errors? How do trouble-shoot them?
What is the purpose of joins in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain fastload in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.