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 / pavan
The update is not accessible,so we cannot use the FLOAD
Utility why because FLOAD is the utility only used to
insert that to incae of empty tables only. and we can go
for MLOAD utility.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are tpump utility limitations?
What is meant by Teradata Gateway?
What is meant by a dispatcher?
What are the updated features of teradata?
Explain BYNET.
How can you track login parameters of users in teradata?
What do you mean by teradata intellicloud?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Differentiate database data and data warehouse data?
what are the day to day activities of teradata DBA ?
Differentiate primary key and partition key?
Explain the most common data types used in teradata?
What interface is used to connect to windows based applications?