If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
Answers were Sorted based on User's Feedback
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 |
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 |
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What is domain in terms of informatica?
tell me the push down optimization
What are the tasks that source qualifier performs?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
How can yoU improve session performance in aggregator transformation?
Explain your project of banking domian.
wat s mapping parameter and mapping variable? how do you set that in a mapping?
what is dynamic cashe
What are the mapping paramaters and mapping variables?