What is called partitioned primary index (ppi)?
No Answer is Posted For this Question
Be the First to Post Answer
What is the Maximum number of volatile tables that can be created?
What are the functions of a teradata dba?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
Where we use PPI in real time??? What is the disadvantages of PPI?
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 is the difference between fastload and multiload?
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
In Teradata, how do we Generate Sequence?
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
can we join volatile table with general table an global temporary table with general table ?
In Teradata, what is the significance of UPSERT command?