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 is the use of stored procedures in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How many types of joins are there in teradata?
What are two examples of an OLTP environment?
what is meant by Hot amp?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
What is dimensional modeling?
what is the default character set in teradata,,?
Highlight the limitations of TPUMP Utility.
How will you solve the problem that occurs during update?
What are the joins in teradata and how many types of joins are there in teradata?
What are the uses of client software involved in teradata?