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 multi insert?

984


Explain teradata vs. Redshift?

956


How to view every column and the columns contained in indexes in teradata?

980


What is bteq utility in teradata?

916


What are the joins in teradata and how many types of joins are there in teradata?

960


What is the opening step in basic teradata query script?

977


In general, how do you optimze any sql in teradata?

974


Explain the meaning of Amp?

1034


Explain the term 'row' related to relational database management system?

886


What is the use of stored procedures in teradata?

942


What is bteq script in teradata?

1077


What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1057


What is primary index and secondary index?

973


What tools would you use for that?

1028


What is upsert statement in teradata?

1051