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 |
Explain the term 'row' related to relational database management system?
How many macros we can create inside a macro
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
can i call router is a passive transformation
Can any one please provide me practical example of How to do the performance tuning in Query??
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
Highlight the points of differences between the database and user in Teradata.
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
What exactly do you know about catching in teradata?
What is the difference between SI and JI?