sree


{ City }
< Country > india
* Profession *
User No # 85026
Total Questions Posted # 0
Total Answers Posted # 4

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 4
Questions / { sree }
Questions Answers Category Views Company eMail




Answers / { sree }

Question { Infosys, 39111 }

How to list Top 10 salary, without using Rank Transmission?


Answer

SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10

Is This Answer Correct ?    0 Yes 0 No

Question { Patni, 8360 }

What is degenerated dimention table?


Answer

A degenerared dimension is a dimension which is having one
attribute,and is placed in a fact table.

for ex: invoice no

Is This Answer Correct ?    1 Yes 0 No


Question { Oracle, 4902 }

followin source like

region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200


Answer

use java Transformation(through code we can solve this)

Is This Answer Correct ?    3 Yes 4 No

Question { Polaris, 6710 }

source
name sal
aaaa 2000
bbbb 3000
abcd 5000


Target
name sal
aaaa 2000
bbbb 3000
abcd 5000
total 10000


how to get total as new row and sum as 10000

thanks


Answer

actually i need total as new record value as 10000

Is This Answer Correct ?    0 Yes 0 No