We are migrating an oracle table into teradata, the volume
of data is huge and partitioned (year wise list partition).
How do i simulate the same in teradata.
- 2 Answers
- 6536 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
PPI can be a better option. Using PPI, data can be
partitioned using months also.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'columns' related to relational database management system?
How will you solve the problem that occurs during update?
What are the various indexes in teradata? How to use them? Why are they preferred?
Did you write stored procedures in teradata?
Why does varchar occupy 2 extra bytes?
What is the purpose of using case expression in teradata?
How many tables can you join in v2r5?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are teradata utilities?
What is teradata? Also, list out some of the primary characteristics of teradata.
Describe the between keyword in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
what are the day to day activities of teradata DBA ?
Write a program to show the parser component used in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
