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 dimensional modeling?
What are normalization, first normal form, second normal form and third normal form?
Explain the term 'database' related to relational database management system?
Describe primary index in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Why teradata is used?
What are the functions involved in shared information architecture?
What is a sparse index?
What is the command in bteq to check for session settings ?
What are the different methods ot loading a dimension table? A fact table etc?
if collect stats but it show low confidence why?
What is multi insert?
What are the available primary index types in teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Describe the set operators in teradata.