Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table with emp id, emp name, dept id and sal where
dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any
one explain how it will fetch the record.
- 4 Answers
- 10285 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva reddy
in case we are using nusi in this swicthvation subtable is created same amps.it is one of the full table scan but not full table scan.it's scan only all amps sub table.if any one of the match it will disply.here no allgorithem can be performed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Highlight the points of differences between the database and user in Teradata.
Explain the term 'tables' related to relational database management system?
What are the different design perspectives used in teradata?
Difference between stored procedure and macro?
Syntax for case when statement?
How can we check the version of Teradata that we are using currently?
what is sysdba and sysdbc ? which has high priority ?
Highlight the limitations of TPUMP Utility.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What tools would you use for that?
Mention a few of the ETL tools that come under Teradata.
What are the frequently used data types in teradata?
What is node? How many nodes and amps used in your previous project?
Why teradata is used?
