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 6084There 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 7588write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
3 6657what is the query for retrieve the unique values(not display the duplicates values) from single table?
6 8076how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
2 5613one 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 5932Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
1 4175Post New IBM Teradata Interview Questions
How to build a url from uri?
What are benefits of expert systems?
Describe about luciferase reporter assay?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is active and passive NameNode in Hadoop?
Define about funclib()
Why microsoft word is important?
Define dynamic scoping.
How do I find the start menu?
Explain different types of reports?
Is Hive useful when making data warehouse applications?
What is the difference between python append () and extend () functions?
What is RSAREF?
Explain recursive function & what is the data structures used to perform recursion?
Can you establish a peering connection to a vpc in a different region?