How to copy 1 million records from one DB to another, Which
is effective interms of performance?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
How to run the Teradata jobs in unix environment ???
How many tables can you join in v2r5?
How is Teradata in current market?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Explain fastload in teradata?
If table have access lock.In the same table write lock is posible or not?
List the logical and conditional operators that are used with teradata along with their meanings?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
what is referential constraints?how do you implement RI in teradata?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
What is teradata? Also, list out some of the primary characteristics of teradata.