What are the types of tables in Teradata
Answers were Sorted based on User's Feedback
Answer / vinay
As far as i my knoweledge goes we have ,correct me if i am
wrong.
1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
5 VOLATILE TEMPORARY TABLES
These are the five kind of tables.
| Is This Answer Correct ? | 12 Yes | 17 No |
Answer / vinay
as far as i my knoweledge goes we have ,correct me if i am
wrong.
1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
and there is one more i reckon which i cant remember.
| Is This Answer Correct ? | 7 Yes | 25 No |
Explain fastload in teradata?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
What is differnce between Error code and Error Level in Bteq
what is the default character set in teradata,,?
Explain BYNET.
During the Display time, how is the sequence generated by Teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
how many modules are there in telecome domain?how to explain the architecture?
How you will check the version of teradata?
How many tables can you join in v2r5?