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.
Answers were Sorted based on User's Feedback
Answer / tdguy
PPI can be a better option. Using PPI, data can be
partitioned using months also.
| Is This Answer Correct ? | 2 Yes | 0 No |
What are the available primary index types?
Why is the case expression used in teradata?
Explain fastload in teradata?
Name the five phases that come under MultiLoad Utility.
While creating table my dba has fallback or no fallback in his ddl. What is that?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
What are the functions of a teradata dba?
What do you mean by ttu in teradata?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
What is the maximum number of dml can be coded in a multiload script?
How can we load single row of data into teradata database. please give me the process.