what are the default access rights in the teradata?
Answer / yuvaevergreen
Sel * from dbc.allrights where tablename='' and databasename='' will give you the access rights.
| Is This Answer Correct ? | 7 Yes | 4 No |
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is TPD?
If the table does not have duplicates then which utility you can suggest to load the data ?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
Define views in teradata with syntax.
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
In your project what type of issues and errors you facing in Teradata
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Find 2 highest sal from each dept who have completed 5 year in org
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
How do you load Multiple files to a table by using fastload scripts?