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
What are some examples of informatica etl programs?
What are the types of caches in lookup? Explain them.
What is a node in Informatica?
What's the layout of parameter file (what does a parameter file contain?)?
Explian the Process of deployment groups in informatica
What do think which one is the better joiner or look up?
What is transformation?
Explain why we use partitioning the session in informatica?
What are junk dimensions?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the new features of informatica 9.x in developer level?
What is fact table? Explain the different kinds of facts.
Explain the different dimensions.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
