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
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are tpump utility limitations?
In general, how do you optimze any sql in teradata?
In BTEQ, how are the session-mode parameters being set?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Highlight the advantages of PPI(Partition Primary Index).
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Differentiate database data and data warehouse data?
What are the joins in teradata and how many types of joins are there in teradata?
What are the available primary index types in teradata.
Highlight a few of the important components of Teradata?
What is the maximum number of dml can be coded in a multiload script?
How can bottlenecks be identified?
What do you mean by ttu in teradata?