write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
IBM,
3 8129If 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 ?
2528what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 10249"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 12747how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
IBM,
2 6775one 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 7265can we join volatile table with general table an global temporary table with general table ?
IBM,
4 10343
What are tpump utility limitations?
What is the use of fallback?
Explain amp in teradata?
How do you define Teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the various indexes in teradata? How to use them? Why are they preferred?
Which is faster fastload or multiload?
What is spool space?
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 is meant by a node?
Describe primary index in teradata. And what are the available primary index types?
How to Extract data from multiple legacy systems?
What is smp and mpp platforms?
Mention a few of the ETL tools that come under Teradata.
What happens in a conflict? How do you handle that?