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

What is a clique?

1071


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

4359


What is the use of virtual processor connectivity in teradata?

982


Explain BYNET.

983


Explain teradata architecture?

1067


How do you set the session mode parameters in bteq?

1086


Explain and compare pros and cons of snow flake schemas?

1018


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1936


What are the newly developed features of Teradata?

1006


How can you track login parameters of users in teradata?

1174


What is a node in teradata?

980


What are the various indexes in teradata? Why are they preferred?

991


What are the uses of bynets in multi-node systems?

1009


Define views in teradata with general syntax.

1015


what is sysdba and sysdbc ? which has high priority ?

3812