Answer Posted / shashiall
Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain lookup transformation source types in informatica
State the differences between sql override and lookup override?
What is the command used to run a batch?
What are the different options available for update strategy?
What is fact table? Explain the different kinds of facts.
How to load the data from a flat file into the target where the source flat file name changes daily?
What is a grid in Informatica?
How to elaborate tracing level?
what is song in infrmatica...?
what is informatica metadata?
How to extract the informatica rejected data?
Tell me about Propagate functions in informatica
Did u used latest transformations of 8.6.0? for what?
Explain the types of transformations?