write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
IBM,
3 7817If 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 ?
2420what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 9794"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 12122how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
IBM,
2 6505one 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 6953can we join volatile table with general table an global temporary table with general table ?
IBM,
4 9977
How to identify ppi columns?
How many tables can you join in v2r5?
What happens in a conflict? How do you handle that?
what are the uses of fact table and dimension table in banking project?
What is the purpose of using case expression in teradata?
What is dimensional modeling?
Why do you get spool space errors? How do trouble-shoot them?
How is MLOAD Teradata Server restarted after execution?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What do you mean by ttu in teradata?
What are the frequently used data types in teradata?
What is upsert statement in teradata?
what are the day to day activities of teradata DBA ?
What are some primary characteristics of teradata?
What is a node in teradata?