write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
IBM,
3 7347If 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 ?
2209what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 9117"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 11163how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
IBM,
2 6118one 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 6584can we join volatile table with general table an global temporary table with general table ?
IBM,
4 9454
Describe the set operators in teradata.
What is the purpose of using case expression in teradata?
What are the available join types in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the meaning of Amp?
What are the components provided on node?
how can we analyze the locks ?
What is smp and mpp platforms?
Describe primary index in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What tools would you use for that?
How can bottlenecks be identified?
How would you load a very large file in teradata in general?
Explain parsing engine in teradata?
How do you define Teradata?