Interested to Buy Any Domain ? << Click Here >> for more details...
If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
- 6 Answers
- 12003 Views
- TCS, I also Faced
- E-Mail Answers
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 r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What are the new features in Informatica 5.0?
What is power play plug in?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is parameter file?
What do you mean by blocking transformation?
Under what condition selecting sorted input in aggregator may fail the session?
why we r using presql&postsql in source qualifier?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
How can u stop a batch?
Teradata 
