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 the various indexes in teradata? Why are they preferred?

955


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2098


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1017


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723


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

1050


why use references rather than pointers in the public api, particularly for arguments which are modified?

936


Why does varchar occupy 2 extra bytes?

1104


What is node? How many nodes and amps used in your previous project?

1060


Explain PDE.

1012


Explain teradata utilities. What is multiload, fast load, tpump?

946


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

979


What are the different table types supported by teradata?

892


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

955


What is stored procedure in teradata?

953


What is smp and mpp platforms?

899