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

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154


Name the five phases that come under MultiLoad Utility.

988


While creating table my dba has fallback or no fallback in his ddl. What is that?

1186


In BTEQ, how are the session-mode parameters being set?

1143


What is the purpose of using case expression in teradata?

1017


What is meant by a Channel Driver?

1249


How is MLOAD Teradata Server restarted after execution?

1267


What is dimensional modeling?

1085


What happens when a node suffers a downfall?

1131


How do you set the session mode parameters in bteq?

1106


How do you do backup and recovery in teradata?

1022


How is MLOAD Client System restarted after execution?

1155


Why is the case expression used in teradata?

1078


What is a node in teradata? Explain

1009


Explain vproc in teradata?

1003