Interested to Buy Any Domain ? << Click Here >> for more details...
what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
- 4 Answers
- 27640 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
what is Active lock explain
How to handle decimal places while importing a flatfile into informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain scd type 3 through mapping.
what is size of u r database?
Implementation methodology
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
What you know about transaction control transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is workflow? What are the components of the workflow manager?
How many number of sessions can one group in batches?
Why is sorter an active transformation?
How to elaborate powercenter integration service?
How many types of sessions are there in informatica.please explain them?
