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 |
Explain the term 'tables' related to relational database management system?
What are the different table types that are supported by teradata?
Why Multiload does not supports USI and supports NUSI?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
Explain teradata architecture?
How to cast date "2015-03-03-012204-000000" to timestamp
What are types of partition primary index (ppi) in teradata?
What are the things to be considered while creating secondary index?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
What is upsert statement in teradata?
Discuss the advantages of using partitioned primary index in a query?