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
- 11845 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 |
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
How to extract the informatica rejected data?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
how to sort date field in infomatica?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
What are the types of data warehouses?
What is A cache?
Which files are created during the session rums by informatics server?
Teradata 
