We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
2 6954There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
4 9033write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
3 7846what is the query for retrieve the unique values(not display the duplicates values) from single table?
6 9851how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
2 6533one 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?
3 6985can we join volatile table with general table an global temporary table with general table ?
4 10010Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
1 4873Post New IBM Teradata Interview Questions
what is datacontrols?
How to add Hibernate mapping file in hibernate configuration file?
Tell me about yourself and why are you interested in this position?
What new data source types were added in ssrs 2014?
How do you kill a service?
What are the different types of classes?
Explain the Aesthetic and Moral values of Science
Define an interface MilitaryPower that has the following properties: • The interface has two public static final variables which are the finite x and y coordinate (i.e. the distance of the objects should not exceed these values. These values set to 100. • The interface has a method move that moves the military power objects to the target value. The method will be implemented by the other classes. The return type should be void. B) Define an enum class Direction which contains the directions (EAST, WEST, SOUTH, NORTH). C) Define a concrete class Tank that implements MilitaryPower, has the following properties: • XCoordinate (Integer), YCoordinate (Integer) are the instance variables for this class. • All instance variables should be private. • Write a parametered constructor that takes two parameters assigning with the instance variables. • Write a set and get method each of the instance variables. • Write a method move that takes two parameters. One of them is distance which type is integer. Another is direction which type Direction. The method should to the following: o If the direction is EAST, set the x-coordinate with adding distance. o If the direction is WEST, set the x-coordinate and subtract distance from x-coordinate. o If the direction is SOUTH, set the y-coordinate with adding distance. o If the direction is NORTH, set the y-coordinate and subtract distance from x-coordinate. • Write a method toString to display the tank coordinates. D) Define an array holding 10 MilitaryPower objects, all of them being a Tank. Then display each of the object information on the screen. (display its movements and coordinates).
What are the roles played by wrappers in uml?
What is a goal seek function?
Why u switch your career from BSC ( foods & nutrition) to MBA ( HRM)
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
How can we create a table using R language without using external files?
Do you know what is virtual memory?
Explain the input procedure and output procedure?