Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?
Answer Posted / bhanu prasad
We can find the information of all the indexes in the
system table "dbc.indices"
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
any one answer me how they can analyzing the project using data ware housing?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
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 upsert statement in teradata?
Explain parsing engine in teradata?
During the Display time, how is the sequence generated by Teradata?
What is spool space?
What do you mean by teradata intellicloud?
What is a three-tier data warehouse?
How can you track login parameters of users in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
Mention a few of the ETL tools that come under Teradata.