write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
IBM,
3 6675If 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 ?
1897what is the query for retrieve the unique values(not display the duplicates values) from single table?
IBM,
6 8088"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 9693how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
IBM,
2 5630one 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 5945can we join volatile table with general table an global temporary table with general table ?
IBM,
4 8684
Mention a few of the ETL tools that come under Teradata.
What do you mean by tpt in teradata?
Is multi insert ansi standard?
Describe primary index in teradata?
Highlight a few of the important components of Teradata?
What is the difference between teradata and oracle?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
When tpump is used instead of multiload?
What are the different functions included in the server software?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are the various indexes in teradata? Why are they preferred?
What are some commonly used bteq scripts?
What is the difference between union and union all in teradata?
what is sysdba and sysdbc ? which has high priority ?
Highlight the points of differences between the database and user in Teradata.