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


Please Help Members By Posting Answers For Below Questions

What are the different methods ot loading a dimension table? A fact table etc?

551


Explain the advantages of partitioned primary index in a query?

543


While creating table my dba has fallback or no fallback in his ddl. What is that?

662


Explain and compare pros and cons of snow flake schemas?

583


What are the available primary index types in teradata.

560






Explain the new features of teradata?

540


Explain amp in teradata?

550


What is the difference between fastload and multiload?

750


What is node? How many nodes and amps used in your previous project?

646


Why do you get spool space errors? How do trouble-shoot them?

562


What is the purpose of joins in teradata?

514


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

556


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3883


Explain fastload in teradata?

571


Highlight a few of the advantages that ETL tools have over Teradata.

583