Interested to Buy Any Domain ? << Click Here >> for more details...
Could any one to tell How to use the Oracle Analytic
functions in Informatica?
- 1 Answers
- 11717 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabyasachi
Some of theOracle Analytical functions are like DENSE_RANK
(), RANK(),CUM_DIST(),CUM_AVG() etc. One get the
fuctionalities of some of these functions such as rank by
using a rank transformation.
For other types of functions one can resort to custom
transformation.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
permutations of mapplet
What is informatica metadata and where is it stored?
What are the types of data warehouses?
Briefly describe lookup transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are junk dimensions?
What is the difference between Active and Passive transformation?
Can u generate reports in Informatica?
How do you load only null records into target?
What is the function of union transformation?
What is xml source qualifier transformation in informatica?
Which version configuration tool used in ur project?
How to generate sequence numbers using expression transformation?
Which transformation should we use to normalise the COBOL and relational sources?
What are the new features of informatica 9.x developer?
