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.
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
What is the use of fallback?
What do you mean by teradata sql assistant?
What is meant by a Highest Cost Plan?
What are the 5 phases in a multiload utility?
Highlight the advantages of PPI(Partition Primary Index).
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various reporting tools in the market?
What is difference between user and database in teradata?
Explain Teradata performance tuning and optimization?
What are the uses of bynets in multi-node systems?
What are the different table types supported by teradata?
What is multi insert?
How to Extract data from multiple legacy systems?
Explain teradata utilities?
Describe primary index in teradata?