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
Steps to create a data model?
Explain the types of join supports by teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Why teradata is used?
What is the basic syntax for teradata select statement?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is the primary index in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
How to run a query in teradata?
How will you solve the problem that occurs during update?
In BTEQ, how are the session-mode parameters being set?
how can we analyze the locks ?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is oltp?
What are the enhanced features in teradata v2r5 and v2r6?