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?
CTS,
3 10555How 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
1 10121Suppose 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 load
4 8019How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13756what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
HCL,
3 11755
How to view every column and the columns contained in indexes in teradata?
How to select first n records in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
how many modules are there in telecome domain?how to explain the architecture?
What is meant by a node?
any one answer me how they can analyzing the project using data ware housing?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is meant by a Clique?
What are the enhanced features in teradata v2r5 and v2r6?
How does hashing happens in teradata?
Highlight a few of the important components of Teradata?
What is meant by Teradata Gateway?
What are the steps involved after the disk manager passes the request?
What is the difference between fastload and multiload?