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 |
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Give some points about Teradata Viewpoint ?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
What are the steps involved after the disk manager passes the request?
Explain the teradata primary index mechanics in detail with a diagram.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is a clique?
What is meant by Teradata Gateway?
Which is more efficient group by or distinct to find duplicates?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
What are the steps involved in the process flow of the sql statement through channel attached system?