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


Please Help Members By Posting Answers For Below Questions

Steps to create a data model?

668


Explain the types of join supports by teradata?

592


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 ?

1902


Why teradata is used?

584


What is the basic syntax for teradata select statement?

583






Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

596


What is the primary index in teradata?

593


What are the joins in teradata and how many types of joins are there in teradata?

579


How to run a query in teradata?

591


How will you solve the problem that occurs during update?

589


In BTEQ, how are the session-mode parameters being set?

670


how can we analyze the locks ?

1702


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3914


What is oltp?

574


What are the enhanced features in teradata v2r5 and v2r6?

697