TERADATA-SQL-TUTORIAL

Q46) How to check all the volatile tables created for the current session ? Ans46) HELP VOLATILE TABLE; Q47) How to specify security mechanism option in BTEQ? Ans47) We can use logmech command to specify security mechanism in BTEQ in Teradata eg: .LOGMECH LDAP; Q48) What is datatype of keyword NULL ? Ans48) NULL keyword is of INTEGER datatype. Q49) ORDER BY clause is not allowed along with SELECT clause in which situation ? Ans49) In Subqueries Q50) Can you specify ORDER BY COLUMN_NAME in SET OPERATORS like UNION/MINUS etc ? Ans50) No. If you need to use ORDER BY , then specify COLUMN ORDERRead More →

TERADATA-SQL-TUTORIAL

How well do you know about Teradata SQL Assistant ? Check below questions related with TSA: Q41) Date column is not shown properly in TSA. How to overcome this issue? Ans41) CAST the date column into varchar, now the date column will be displayed in proper format. Q42) How can I change NULL and DATE values representation in TSA? Ans42) Go to TOOLS –> OPTIONS –> DATA FORMAT Q43) When we get the error in TSA, we can see it in bottom status bar. However how to see last encountered error when we have executed some other successful query? Ans43) You can press F11 andRead More →

TERADATA-SQL-TUTORIAL

Q36) Name three result code variables in Stored Procedures? Ans36) SQLSTATE, SQLCODE, ACTIVITY_COUNT. Q37) What is the default value for any three result code variables? Ans37) SQLSTATE : ‘00000’, SQLCODE: 0,ACTIVITY_COUNT: 0 Q38) What are the SQL SECURITY Options available in Stored Procedures in Teradata? Ans38) SQL SECURITY OWNER/CREATOR/DEFINER/INVOKER Q39) What is the default SQL SECURITY OPTION in Stored Procedures in Teradata? Ans39) SQL SECURITY DEFINER Q40) I want to process all the column values in some table using Stored Procedure. How to implement it in Teradata ? Ans40) We can use REF CURSOR to implement this in Stored Procedure in Teradata.Read More →

TERADATA-SQL-TUTORIAL

Q31. While exporting data using BTEQ Export, you are getting junk characters in the exported file. How will you remove these junk characters ? Ans31. Add a BTEQ setting before your SELECT clause in BTEQ Export: .SET RECORDMODE OFF; Q32. While retrieving COUNT(*) in your SQL Query, it is giving numeric overflow error. How will you get the count now ? Ans32. Try to cast count(*) to some other bigger datatype in order to avoid numeric overflow error: SEL CAST(COUNT(*) AS DECIMAL(18,0)) FROM TABLE_NAME; Q33. Will the count be same if we use COUNT(*), COUNT(20), COUNT(COLUMN_NAME) from some table ? Ans33. COUNT(*) and COUNT(20) willRead More →

In Teradata we can have so many interview questions . So I thought of listing down few of the interview questions which are very common and almost in all the interviews these questions are asked. Hope it will help. Below Questions are related to Teradata Multiload Interview Questions: Q26. How many populated tables are supported by MultiLoad? Ans26. Teradata can support upto 5 populated tables. Q27. What are the DML operations possible in MultiLoad? Ans27. INSERT, UPDATE, DELETE and UPSERTS are possible in Multiload. Q28. Does Multiload use Transient Journaling ? Ans28. Multiload does not use Transient Journaling. It uses a LOG table to maintainRead More →

TERADATA-SQL-TUTORIAL

In Teradata we can have so many interview questions . So I thought of listing down few of the interview questions which are very common and almost in all the interviews these questions are asked. Hope it will help. Q21. How to save a string with single quote (‘) as part of the value? Ans21. INSERT INTO CUSTOMER(COMMENTS) VALUES(‘I”m Good’); Q22. How to select 5th row from a table? Ans22. SELECT * FROM TABLENAME QUALIFY ROW_NUMBER() OVER (ORDER BY COLUMN1) = 5; Q23. Where is password stored in Teradata? Ans23. User can view the password in DBC.DBASE view however it will be in encrypted format.Read More →