write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
IBM,
3 7838If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
2427what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 9836"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
9 12164how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
IBM,
2 6522one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
IBM,
3 6973can we join volatile table with general table an global temporary table with general table ?
IBM,
4 9999
Comment whether bottleneck is an error or not.
What is a sparse index?
why use references rather than pointers in the public api, particularly for arguments which are modified?
How to select first n records in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is the maximum number of dml can be coded in a multiload script?
What is collect statistics?
What is a dimension table?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How many tables can you join in v2r5?
What is bteq script in teradata?
What is a node in teradata? Explain
Explain PDE.
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?
Describe primary index in teradata?