Interested to Buy Any Domain ? << Click Here >> for more details...
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 10417How 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 10056Suppose 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 7787How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13666what 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 11603
What are the various indexes in teradata? Why are they preferred?
Why is the case expression used in teradata?
What is the use of having index on table?
how do you manage the production space. what are the proactive methods you can take ?
What is the use of teradata system software?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the design features involved in teradata?
Which is faster fastload or multiload?
In BTEQ, how are the session-mode parameters being set?
Describe the set operators in teradata.
What is teradata and why it is used?
What is node? How many nodes and amps used in your previous project?
How to Extract data from multiple legacy systems?
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 logical data model?
