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
- 11975 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 |
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
What is session task and command task?
How to delete first 3 rows & last 3 rows in target table in informatica
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What is data movement mode in Informatica and difference between them?
explain different types of modeling.
Different types of Power center errors?
without dynamic lookup how to insert new rows and update existing rows?
Can you generate reports in Informatcia?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Why we require dwh in particular projects?
Teradata 
