What is SQL Assistence?please eample
Answers were Sorted based on User's Feedback
Answer / vinay sir(datawarehousing tech
Sql Assistant(Before Teradata13 we used to call this
formally as Queryman)uses ODBC driver to
connect and work with any ODBC complaint
databases(Oracle,Sqlserver etc...)
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sharada
if data is in less quantity then we can use sql assisatance
this is called as query man also. By using query man we can
export and import data
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramesh g
sql assistance is a tool,here we can
objects,macros,procedures, and also select,insert,update,
delete,drop object as well as rows and this is also called
as queryman
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tdguy
SQL assistant is a tool using which users submit the
queries to teradata and view or export the resultset.
Import option is also available.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of fallback?
Why do Hash joins usually perform better than Merge Joins?
What is the syntax for case when statement?
What are the primary characteristics of the Teradata.
How many codd's rules are satisfied by teradata database?
What do you mean by ttu in teradata?
Discuss the advantages of using partitioned primary index in a query?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
What is Difference b/w PI & PPI?how to implement PPI?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
What is oltp?