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
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
What is upsert statement in teradata?
How do you verify a complicated sql?
What are the components used in smp and massively parallel processing (mpp) machines?
What is teradata? Also, list out some of the primary characteristics of teradata.
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
what is object level locking ? where do appear this type of locking ?
What is teradata?
What is primary index and secondary index?
What are the uses of client software involved in teradata?
What is meant by a node?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the available join types in teradata?
List out teradata data types?
List out some of the primary characteristics of teradata.
Explain and compare pros and cons of snow flake schemas?