in ur table contains the coloumns like deptno,sal empname
then i want output as
deptno subtotalofdept totalsal
10 3700 3700
20 3400 7100
like that
What is the multi-insert?
What is the purpose of using case expression in teradata?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What are the various indexes in teradata? Why are they preferred?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
What are the components provided on node?
Explain PDE.
what are the file sizes in your project?
Explain fallback in teradata?
What is Difference b/w PI & PPI?how to implement PPI?
How do you eliminate duplicates?