Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to copy 1 million records from one DB to another, Which
is effective interms of performance?

Answer Posted / yuvaevergreen

in case of data migration from one db to another db in two
different environments, nparcd utility or (fastexport to a
file followed by multiload) should be used. But within the
same environment, a simple insert statement would do.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In Teradata, how do we Generate Sequence?

1090


What is the function of parser component in teradata?

1131


What is the purpose of using case expression in teradata?

1066


Write a program to show the parser component used in teradata?

1027


What is the use of virtual processor connectivity in teradata?

1094


What are the various reporting tools in the market?

1115


How is MLOAD Teradata Server restarted after execution?

1342


Explain the meaning of Amp?

1240


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

4421


What are the components used in smp and massively parallel processing (mpp) machines?

1095


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1212


What is the use of stored procedures in teradata?

1046


What is logical data model?

1260


What is primary index and secondary index?

1066


List out all forms of LOCKS that are available in Teradata.

1011