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 is a node in teradata?

1049


What is the difference between teradata and basic rdbms?

1072


Explain and compare pros and cons of snow flake schemas?

1087


Highlight the need for Performance Tuning.

1154


What is the purpose of indexes?

1128


How do you verify a complicated sql?

1113


What is a three-tier data warehouse?

1151


When tpump is used instead of multiload?

1143


What are the components provided on node?

1089


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1317


Give the sizes of SMALLINT, BYTEINT and INTEGER.

1210


What are the steps involved in the process flow of the sql statement through channel attached system?

1159


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

1157


How to find duplicates in a table?

1272


How many sessions of MAX is PE capable of handling at a particular time?

1135