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...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

How to copy 1 million records from one DB to another, Which
is effective interms of performance?

Question Posted / mmc

Answers were Sorted based on User's Feedback



How to copy 1 million records from one DB to another, Which is effective interms of performance?..

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

How to copy 1 million records from one DB to another, Which is effective interms of performance?..

Answer / tdguy

I hope TD data mover (recently introduced) can be used to
copy db objects from one DB in a system to another system.

Is This Answer Correct ?    2 Yes 0 No

How to copy 1 million records from one DB to another, Which is effective interms of performance?..

Answer / rakesh

You can use NPARC process for copy data from tables in one
database to another tables in different database

Is This Answer Correct ?    2 Yes 1 No

How to copy 1 million records from one DB to another, Which is effective interms of performance?..

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

More Teradata Interview Questions

Differentiate database data and data warehouse data?

0 Answers  

Explain the term 'primary key' related to relational database management system?

0 Answers  

What is meant by a Virtual Disk?

0 Answers  

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

what are the day to day activities of teradata DBA ?

0 Answers   TCS,

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

What are the enhanced features in teradata v2r5 and v2r6?

0 Answers  

How does hashing happens in teradata?

0 Answers  

Explain PDE.

0 Answers  

How will you solve the problem that occurs during update?

0 Answers  

What is smp and mpp platforms?

0 Answers  

Difference between star and snowflake schemas?

0 Answers  

For more Teradata Interview Questions Click Here
Categories