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 is a node in Informatica?
EXL informatica Questions
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
what is a transforamation?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
what is mystery dimension?
Differentiate between a repository server and a powerhouse?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
 Code page compatibly –Where all changes are made to handle the scenario.
in which situations do u go for sequence generator ?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the main difference between a Joiner Transformation and Union Transformation?