Home
Contact
About
Navigation
Home
Interview Questions
Tutorials
Video Tutorials
Home
»
Teradata Interview Questions
»
Write a Query to find the last date of last(previous) month.
Write a Query to find the last date of last(previous) month.
in
Teradata Interview Questions
- on 03:22 -
No comments
SELECT CURRENT_DATE-EXTRACT(DAY FROM CURRENT_DATE);
Tweet
Post a Comment
Newer Post
Older Post
Home
Categories
Teradata Interview Questions
Recent Comments
Popular Posts
What can be done to release fload locks?
1. Finish the fastload, which means leave your hands off of the error tables and restart fastload. When it finishes the table lock will be ...
What is identity column in TD?
In Teradata the identity column is the one, where the value gets inserted automatically (w/o any ETL intervention), by the described interva...
What is the difference between start schma and Fsldm?
FSLDM --> Financial Services Logical Data Model (Teradata FS-LDM 7.0) its developed by Teradata for the financial sectors (Speciafially f...
Teradata Scenario - interview question
A scenario like ,there is a BTEQ where it has delete statement followed by an insert and update.Suppose the delete statement has been execut...
What is the difference between Multiload and Fastload interms of Performance?
If you want to load, empty table then you use the fastload, so it will very useful than the multiload..because fastload performs the loading...
how do you handle ET and UV errors in MLOAD (ET = Error table)?
In mload ET and UV tables, source sequence of the error records in the input file would be present. Use that number and delete/correct the...
What is the process to restart the multiload if it fails?
MULTILOAD will creates 2 error tables, 1 work table When MULTILOAD fails We have to unlock the Main Table, here error tables and work tables...
Which is more efficient GROUP BY or DISTINCT to find duplicates?
With more duplicates GROUP BY is more efficient, if only a few duplicates exist DISTINCT is more efficient.
How would you execute the BTEQ?
Consider a BTEQ script contains the following code in it. .logon tpid/user, pass; /* Login credentials */ SEL * FROM tab_a; /* Que...
What is error table? What is the use of log table?
The Error Table contains information concerning: - Data conversion errors Constraint violations and other error conditions: * Contains r...
Live Traffic Stats
Post a Comment