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 do you mean by channel change?
What are some examples of informatica etl programs?
What is a command that used to run a batch?
connected and unconnected lookups?
How to delete the (flat file) data in the target table after loaded.
define galaxy repository in informatica
What are different types of transformations available in informatica?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Can we create multiple integration service on single repository?
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
enterprise datawarehouse your project phase by phase explain?