sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
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 varaibale1 7881
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load4 5330
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
What is the difference between global temporary tables and volatile temporary tables?
What is the multi-insert?
In Teradata, how do we Generate Sequence?
What are the available primary index types in teradata.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is real time and near real time data warehousing?
Did you write stored procedures in teradata?
What do you mean by parsing?
What is spool space? Why do you get spool space errors?
What is bteq utility in teradata?
What are differences between teradata and ansi session modes in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are normalization, first normal form, second normal form and third normal form?
Mention a few of the ETL tools that come under Teradata.
What is the opening step in basic teradata query script?