Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table like sales....the field are
Prodid Jan(jam month sales)Feb March apr may jun july
1 20 76 50 74 94 93 83
2 30 94 40 94 93 93 02
3 40 90 30 49 94 92 56
4 70 20 30 93 46 35 78
5 23 40 40 39 84 46 57
6 85 30 55 93 46 46 46
7 84 20 65 83 56 57 57
8 10 93 40 93 68 57 36
9 57 30 30 83 67 57 79
10 38 83 40 83 55 68 47
11 35 39 90 94 57 78 47
12 83 89 50 93 79 69 69
i wat ti find the max sales of every product which i want to
load into target table
- 6 Answers
- 11285 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Vaishnavi...i think the data presented here is already in a
reporting format...because sales amount for each month for
each prod id has been aggregated column wise. As far as I
know,any aggregate function like max,min,sum,count could
be applied only to row wise data. In case of manipulation
of column wise data, we may have to go with case statement
or we may have to transpose the column wise data to row
data for the manipulation to be done. So in this case,
either case statement has to be used for comparison of
column data or column to row transposition has to be done
by utilizing union statement(sel jan from table union sel
feb from table...till dec) and then the max value function
can be applied. Or if creation of volatile/temp tables is
allowed, then the above result can be stored temporarily
and manipulations can be done. Other option would be to
create UDF, but i think that has to be looped(thru SP i
think..not sure)...This is my opinion. Suggestions are
welcome.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Define views in teradata with general syntax.
What is spool space? Why do you get spool space errors?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the term 'database' related to relational database management system?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Explain the parallel data extension in teradata?
Explain the term 'columns' related to relational database management system?
Explain the meaning of Amp?
What is the purpose of upsert command?
Explain amp in teradata?
How to identify ppi columns?
How is MLOAD Teradata Server restarted after execution?
Why does varchar occupy 2 extra bytes?
What is the maximum number of dml can be coded in a multiload script?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
