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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain the difference between mapping parameter and mapping variable?
How to create a non-reusable instance of reusable transformations?
how to create user defined function (udf) in informatica
What is the need for an etl tool?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How do you load alternate records into different tables through mapping flow?
Explain why we use partitioning the session in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is meant by lookup transformation?
What is dynamic cache?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of schemas we have in data warehouse.
Briefly define reusable transformation?
How can we improve session performance in aggregator transformation?