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 / tdguy
Incase if you have priveleges to delete the data, delete
and load all the 4 columns using fload utility. Else use
bteq and load all the 4 columns in a volatile table
followed by delete and loading into target table. But this
would be slow when compared to fload.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the commands to make a new table, change a table and remove a table in teradata?
Mention a few of the ETL tools that come under Teradata.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is called partitioned primary index (ppi)?
what are the uses of fact table and dimension table in banking project?
What are the different methods ot loading a dimension table? A fact table etc?
any one answer me how they can analyzing the project using data ware housing?
What do you mean by tpt in teradata?
What is a clique?
What is a sparse index?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is basic teradata query language?
What is the purpose of upsert command?