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
- 27765 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
Explain the difference between a data warehouse and a data mart?
What are the data movement modes in informatica?
Under which circumstances, informatica server creates reject files?
Is there any way to read the ms excel datas directly into informatica?
How to create the source and target database connections in server manager?
How to generate sequence numbers?
What is rank index in rank transformation?
What does role playing dimension mean?
What is dimensional table? Explain the different dimensions.
how tokens will generate?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is data caches/ index caches?
How are indexes created after completing the load process?
Explain why we use partitioning the session in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
