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 |
In Teradata, what is the significance of UPSERT command?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the uses of client software involved in teradata?
Name the five phases that come under MultiLoad Utility.
How to copy 1 million records from one DB to another, Which is effective interms of performance?
How do you determine the number of sessions?
What is the maximum number of dml can be coded in a multiload script?
How to run the Teradata jobs in unix environment ???
What is bteq utility in teradata?
What are the functions of a teradata dba?
Highlight all the modes that are present under Confidence Level.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?