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 / ugandhar

I hope you mean from one TD to other TD. Like Production
Terdata to Dev Teradata database.
In this case, write a fastexport to export the data and a
fastload/mload script to load it to other database.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are default access rights in teradata?

1136


What is real time and near real time data warehousing?

1123


What are some primary characteristics of teradata?

1006


Name the five phases that come under MultiLoad Utility.

994


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

991


What are the scenarios in which full table scans occurs?

1013


What does sleep function does in fast load?

1146


Explain and compare pros and cons of snow flake schemas?

1036


If RDBMS is halted what will you do ?

2177


What is the purpose of upsert command?

1183


What does Amp contain and what are all the operations that it performs?

1009


What is teradata and why it is used?

1107


What are some commonly used bteq scripts?

1023


How many codd's rules are satisfied by teradata database?

1118


How do you do backup and recovery in teradata?

1028