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


Please Help Members By Posting Answers For Below Questions

What is the multi-insert?

589


Describe primary index in teradata. And what are the available primary index types?

529


Differentiate database data and data warehouse data?

571


What is TPD?

890


Explain teradata architecture?

618






What are the joins in teradata?

551


What is meant by a Virtual Disk?

564


Describe the set operators in teradata.

570


Did you write stored procedures in teradata?

604


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1752


Why are oltp database designs not generally a good idea for a data warehouse?

583


What are the primary characteristics of the Teradata.

571


In Teradata, what is the significance of UPSERT command?

579


How would you load a very large file in teradata in general? What utility would you use for it? Why?

576


Difference between star and snowflake schemas?

591