If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
Answer Posted / 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 |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the tuning techniques you applied during your last project
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Why sorter is an active transformation?
What are the new features of informatica 9.x in developer level?
What is the function of look up transformation?
Define Pmrep command?
What are the limitations of joiner transformation?
What are the main issues while working with flat files as source and as targets ?
How can you differentiate between powercenter and power map?
Describe the impact of several join conditions and join order in a joiner transformation?
What is rank index in rank transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Is it possible to revert a global repository to local one and why?
waht type of interface is used for testing the data in informatica