If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can ra

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values

Question Posted / guest

6 Answers
11855 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / sam

1,2,3,3,4,,4,5
1,2,3,3,5,5,7

Is This Answer Correct ?

28 Yes

1 No

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / kondeti srinivas

explanation for sam.
sam has given currect ans 1,2,3,3,5,5,7

upto 1,2,3 is fine after 3 again itput is 3 for that rank
t/f give rank as 3 after rank t/f skip 4 ranks becasue it
already given rank for repeaded value and for null values
it rank will not give any rank

Is This Answer Correct ?

2 Yes

0 No

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / sanjay

Sam is 100% correct...

Is This Answer Correct ?

1 Yes

0 No

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / raveendra g

Can you pls explain breifly?

Is This Answer Correct ?

0 Yes

0 No

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / nitin

Rank transformation in informatica is like rank() function in oracle. that's why it's giving the next value after the repetition of some values.

Is This Answer Correct ?

0 Yes

0 No

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values ..

Answer / sujana

rank
1 1
2 2
3 3
4 4
4 4
5 6

Is This Answer Correct ?

8 Yes

12 No

Post New Answer